13

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

Ladislav Mrnka
  • 355,666
  • 57
  • 651
  • 662
Mike Barlow - BarDev
  • 10,877
  • 16
  • 63
  • 83

1 Answers1

14

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.

Community
  • 1
  • 1
Ladislav Mrnka
  • 355,666
  • 57
  • 651
  • 662
  • 5
    Perfect I did something like this and it seemed to work: context.Database.SqlCommand("ALTER TABLE MyTable ALTER COLUMN MyColumn VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL"); – Mike Barlow - BarDev Mar 12 '11 at 22:36