Migrations: Clustered, Identity & Computed columns are SQL Server specific

dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

https://docs.microsoft.com/ef/

MIT License

13.65k stars 3.15k forks source link

Migrations: Clustered, Identity & Computed columns are SQL Server specific #879

Closed ajcvickers closed 9 years ago

ajcvickers commented 9 years ago

Note that this is different from sequences which are relational everywhere but are currently only used in a SQL Server specific way.

ghost commented 9 years ago

The pull request that removes the relational model separates the "clustered" diffing logic into the SqlSever specific differ. What needs to be done here is to remove isClustered from CreateIndex and AddPrimaryKey operations in Migrations, then added to corresponding SqlServer specific operations (derived classes or same classes with annotations). This probably also requires some small updates in the sql generators (casts to derived class or annotation retrieval)