Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity Framework Code First - Change Table Column Collation

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

like image 904
Mike Barlow - BarDev Avatar asked Mar 12 '11 21:03

Mike Barlow - BarDev


1 Answers

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.

like image 100
Ladislav Mrnka Avatar answered Sep 22 '22 19:09

Ladislav Mrnka