Entity Framework Code First - Change Table Column Collation
ef-code-first, entity-framework, entity-framework-4, entity-framework-ctp5, sql-server
Solution
Model builder doesn't allow this but you can create custom database initializer and execute `ALTER TABLE` command. The example will be the same as this one creating custom index.
Problem
I'm using Entity Framework CTP5 and Code First. I need to change the Collation for a specific column in SQL Server. I believe the default collation is SQL_Latin1_General_CP1_CI_AS, but I need to change this one column colllation to SQL_Latin1_General_CP1_CS_AS (Case Sensitive). Is there a way to use ModelBuilder in Code First to change a specific column collation? BarDev