我首先给EF模型一个跳。我用EF4.1。
这篇文章
我在模型上以及在选项 & gt; 数据库工具 - & gt; O/ R 设计器设置了多面性新对象假名 。
当我从模型中产生一个新的模型时,表格名称总是多元化,那么,能否禁用此功能,也没有任何效果?
OK,我找到了一个实现我想要的目标的方法 但它是一个相当愚蠢的路线。
以复数名称生成 db ( 有趣的是, 它只将表格的映射多元化到类型上, 而不是自动生成的多个连结表格 ) 。
手动重新命名数据库中的表格
从项目中删除模型,并根据现有数据库模型(我刚才重新命名的模型)重新创建模型。
模型现在被正确映射成单词命名表格 。
我等着看有没有人想出一个更明智的方法 来达到这个目的...
生成 DDL 中的表格名称似乎符合“ 实体设置名称” 值( 不同于“ 实体名称 ” ) 。 如果您对实体设置名称进行点名, DDL 中的表格名称也会被点名 。
这将产生可能不希望的效果, 在您的代码中将 empleSet 属性名称单化 。 而不是 :
myDatabase
.Products
.Where...
.Select...
您的代码将看起来像 :
myDatabase
.Product
.Where...
.Select...
可能或可能不是问题
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...