Question

是否有任何人知道如何在EF4(实体框架4)中改变一个实体的列表?

后来的编辑: 我认为,在模型浏览器中找到了表格名称定义的地方。但是,他们的名字只读了,因此不可能用设计师来编辑。此外,在Xml schema的表格名称上没有提及(从一盘查询)。

Answer 1

如果你真的需要更改表格的名称,你可以:

Open EDMX file with XML Editor.
Locate SSDL section in it.
Locate entity set element for example <EntitySet Name="Customers" EntityType="ExampleModel.Store.Customers" Schema="dbo" />.
Add Table="MyTableName" attribute. <EntitySet Name="Customers" EntityType="ExampleModel.Store.Customers" Schema="dbo" Table="MyTableName" />

http://msdn.microsoft.com/en-us/library/bb399604.aspx” rel=“noreferer”CSDL、SSDL、MSL规格。

希望会有所帮助。

Answer 2

另一种解决办法是,在您的<代码>DbContext类别中推翻一种方法。

public class MyDbContext : DbContext
{
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Product>().ToTable("DB_PRODUCTS_TBL");
        // otherwise EF assumes the table is called "Products"
    }
}

Answer 3

我认为,你要求的是把一个实体的地图重新编成表格。你可以点击一个实体,选择表图。这将向贵实体显示表格的绘制。你可以改变那里的情况。然而,当你开始下降时,你只能看到你利用《更新模式》进口的表格。如果该表没有进口,将不予列入。然后,你可以把这些财产适当绘制到表格的栏目。

Answer 4

在模型Browser,或设计表面右翼,实体和选定特性。在财产窗口中,“固定名称”为外地。

这对我来说是行之有效的,但我正在首先设计该表,然后创建数据库。

Answer 5

由于我首先建立了我的数据库,我做了以下工作:

Backed up the *.edmx file.
Changed my database table name.
Did as you suggested by renaming the Entity Set Name in the properties.
I then Updated the model based on my database by right-clicking the entity.
I noticed that the *.edmx file was missing half the lines, so I overlayed the *.edmx file with my backup, opened it in notepad, and did a replace all of my old table name with my new table name.
Rebuilt the MVC Application, tested, and it worked.

Note: Whether all these steps above are needed I don t know, it s just what I tried and it worked for me.

Answer 6

你可以执行一个储存的假体,改变表名称,将表格名称作为变量。然后将所储存的矿石进口到EF4。

CREATE PROCEDURE ChangeTableName
    @TableName varchar(200)
AS
BEGIN
    SET NOCOUNT ON;
    EXEC sp_rename "User", @TableName
END
GO

友情链接