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 vote124 views2 answers
IdentityModelEventSource.ShowPII
C#
1 vote139 views3 answers
C# remove duplicates from list
C#
15 votes122 views10 answers
Hello world
C#
1 vote128 views1 answer
How to get the world position of the edge of an object?
C#
4 votes114 views1 answer
ALWAYS MAximize window on start c#
C#
0 vote160 views1 answer
Unity point between two positions
C#Unity
0 vote122 views1 answer
Barcode print c#
C#
0 vote160 views1 answer
Implementing Banner Ads Unity
C#
0 vote131 views1 answer
How to set the forgound color of listitems in c#
C#
0 vote114 views1 answer
Unity gun clipping through walls
C#