Nullable unique constraint ef

// Add unique nullable index 
string indexName = "IX_UQ_UniqueColumn";
string tableName = "dbo.ExampleClasses";
string columnName = "UniqueColumn";

Sql(string.Format(@"
    CREATE UNIQUE NONCLUSTERED INDEX {0}
    ON {1}({2}) 
    WHERE {2} IS NOT NULL;",
    indexName, tableName, columnName));

Source: stackoverflow.com

Similar codes

0 vote164 views1 answer
Instantiate an object at a certain position unity
C#Unity
5 votes152 views2 answers
How to deactivate an object unity
C#Unity
40 votes141 views5 answers
C# foreach dictionary
C#
2 votes124 views1 answer
Increase variable C#
C#
0 vote118 views1 answer
Check if two timespans intersect c#
C#
4 votes119 views1 answer
Create list with values C#
C#
0 vote121 views1 answer
Visual studio debug copy byte[] from watch
C#
0 vote158 views1 answer
Dirty property unity
C#Unity
2 votes118 views1 answer
Double
C#
11 votes121 views1 answer
How to copy last element in list c#
C#