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 vote277 views1 answer
Unity draw waypoins path
C#Unity
1 vote228 views1 answer
Decimal to string c#
C#
6 votes231 views2 answers
Left moust click unity
C#Unity
-2 votes269 views1 answer
Random position unity 2d
C#Unity
0 vote253 views1 answer
Unity sprite blurry when far
C#
0 vote258 views2 answers
Get first and last item list c#
C#
0 vote264 views1 answer
Blocked script execution in '<url>' because the document's frame is sandboxed and the 'allow-scripts' permission is not set.
C#
7 votes262 views1 answer
Built in methods to order a list c#
C#
0 vote228 views1 answer
List min and Max value in c#
C#
0 vote251 views1 answer
Lucene.net
C#