本文翻譯自《Entity Framework Core: Naming Convention》,由于水平有限,故無(wú)法保證翻譯完全正確,歡迎指出錯(cuò)誤。謝謝!
注意:我使用的是 Entity Framework Core 2.0 (2.0.0-preview2-final)。正式版發(fā)布時(shí),功能可能存在變動(dòng)。
Entity Framework 遷移允許從模型生成數(shù)據(jù)庫(kù),這意味著必須從類名和屬性名生成數(shù)據(jù)庫(kù)對(duì)象的名稱。對(duì)于大多數(shù)人來(lái)說(shuō)使用默認(rèn)名稱是沒(méi)有問(wèn)題的,但是,您的DBA可能會(huì)要求您使用特定的命名約定。例如,一些DBA希望表名大寫(xiě),或者列名使用表名為前綴。
Entity Framework 允許逐個(gè)設(shè)置表名或列名:
protected override void OnModelCreating(ModelBuilder modelBuilder){ modelBuilder.Entity<Blog>().ForSqlServerToTable("Blog"); }
但是,寫(xiě)這些代碼非常無(wú)聊并且容易出錯(cuò),不應(yīng)該逐個(gè)設(shè)置對(duì)像的名稱,您可以通過(guò)修改模型實(shí)現(xiàn)全局設(shè)置。事實(shí)上modelBuilder
是可讀寫(xiě)的,您可以迭代所有對(duì)象并更改其名稱。
public class BloggingContext : DbContext{ public DbSet<Blog> Blogs { get; set; } public DbSet<Post> Posts { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // Singularize table name // Blogs => Blog foreach (var entityType in modelBuilder.Model.GetEntityTypes()) { // Add NuGet package "Humanizer" to use Singularize() entityType.Relational().TableName = entityType.Relational().TableName.Singularize(); } // Prefix column names with table name // Id => Blog_Id foreach (var entityType in modelBuilder.Model.GetEntityTypes()) { foreach (var property in entityType.GetProperties()) { property.Relational().ColumnName = entityType.Relational().TableName + "_" + property.Relational().ColumnName; } } // Rename Foreign Key // FK_Post_Blog_BlogId => FK_Post_Blog_BlogId_Test foreach (var entityType in modelBuilder.Model.GetEntityTypes()) { foreach (var property in entityType.GetProperties()) { foreach (var fk in entityType.FindForeignKeys(property)) { fk.Relational().Name = fk.Relational().Name + "_Test"; } } } // Rename Indices // IX_Blog_Url => IX_Blog_Url_Test foreach (var entityType in modelBuilder.Model.GetEntityTypes()) { foreach (var index in entityType.GetIndexes()) { index.Relational().Name = index.Relational().Name + "_Test"; } } } }
在 Package Manager Console 中運(yùn)行以下命令:
Add-Migration NamingConvention Update-Database
上面的命令將生成以下數(shù)據(jù)庫(kù)架構(gòu):
CREATE TABLE [dbo].[Blog] ( [Blog_BlogId] INT IDENTITY (1, 1) NOT NULL, [Blog_Url] NVARCHAR (450) NULL, CONSTRAINT [PK_Blog] PRIMARY KEY CLUSTERED ([Blog_BlogId] ASC) );CREATE UNIQUE NONCLUSTERED INDEX [IX_Blog_Url_Test] ON [dbo].[Blog]([Blog_Url] ASC) WHERE ([Blog_Url] IS NOT NULL);CREATE TABLE [dbo].[Post] ( [Post_PostId] INT IDENTITY (1, 1) NOT NULL, [Post_BlogId] INT NOT NULL, [Post_Content] NVARCHAR (MAX) NULL, [Post_Title] NVARCHAR (MAX) NULL, CONSTRAINT [PK_Post] PRIMARY KEY CLUSTERED ([Post_PostId] ASC), CONSTRAINT [testFK_Post_Blog_BlogId] FOREIGN KEY ([Post_BlogId]) REFERENCES [dbo].[Blog] ([Blog_BlogId]) ON DELETE CASCADE);CREATE NONCLUSTERED INDEX [IX_Post_BlogId_Test] ON [dbo].[Post]([Post_BlogId] ASC);
您可以看到生成數(shù)據(jù)庫(kù)對(duì)象名稱遵循的命名約定。
轉(zhuǎn)載請(qǐng)注明出處,原文鏈接:http://www.cnblogs.com/tdfblog/p/entity-framework-core-naming-convention.html。
如果您覺(jué)得閱讀本文對(duì)您有幫助,請(qǐng)點(diǎn)一下“推薦”按鈕,您的“推薦”將是我最大的寫(xiě)作動(dòng)力!
歡迎各位轉(zhuǎn)載,轉(zhuǎn)載文章之后必須在文章頁(yè)面明顯位置給出作者和原文連接。
http://www.cnblogs.com/tdfblog/p/entity-framework-core-naming-convention.html