English 中文(简体)
查阅实体框架的实时表格
原标题:Accessing runtime-created tables with Entity Framework

我们的申请是在运行时间创建新表格,但总是采用相同的表格。 这些表格中只有一个到下一个表格中,只有表格名称。 能否利用实体框架查阅这些表格,具体说明哪些表格按姓名查阅?

最佳回答
  1. Entity Framework is not designed for DDL, it s an ORM tool for data access. You would want to use a simple ADO.NET query to create/drop the table.
  2. Creating and dropping tables for every user session will make your log file grow very big very fast. I would consider carefully the reasons you think this is necessary. If the data is temporary, why not save the Session ID in each row and truncate the table on a daily basis?

最新资料:

不是。 实体数据模型并非动态,它是一个固定的XML文件,描述了数据库的结构。 如果你想与一个充满活力的表格进行交流,你将不得不坚持“阶级”的《发展权利宣言》。 NET。

问题回答

With Linq to SQL I guess it would be possible with a stored procedure taking the table Name as a parameter. A nice post about SP in L2SQL: http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

我不知道欧洲自由贸易区是否存在这一特征。





相关问题
Entity Framework with MySQL connector in c#

I have been trying to get the Entity Framework to work in my web application using MySQL. It works fine on my local pc, but doesn t work when I put it on the server. Since the server is a shared ...

How Do I Create And Update A Many To Many Relationship With EF

I am using the Entity Framework with SQL Server. I have a many to many relationship between 2 tables. I have created a join table with just the primary key fields of the 2 tables. In the designer, the ...

Entity Framework with File-Based Database

I am in the process of developing a desktop application that needs a database. The application is currently targeted to SQL Express 2005 and works wonderfully. However, I m not crazy about having ...

Linq to enties, insert foreign keys

I am using the ADO entity framework for the first time and am not sure of the best way of inserting db recored that contain foreign keys. this is the code that i am using, I would appreciate any ...

Entity Framework - Many to many question

I have a table called ASB and a table called PeopleInvolved. There is a junction table called PeopleInvolved_ASB which simply contains an ASBID and a PeopleInvolvedID column. The columns act as a ...

Post back complex object from client side

I m using ASP.NET MVC and Entity Framework. I m going to pass a complex entity to the client side and allow the user to modify it, and post it back to the controller. But I don t know how to do that ...

ADO.NET Entity Data Model are not precise enough

I run this code: var cos = from k in _db.klienci_do_trasy where k.klient_id == 5 select k; but the query send to database is: SELECT * FROM `klienci_do_trasy` LIMIT 0, 30 why is it for, there ...

热门标签