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

55 votes233 views6 answers
C# print
C#
1 vote175 views6 answers
C# ternary operator
C#
3 votes187 views1 answer
How to use the protected keyword in C#
C#
0 vote227 views2 answers
Get index of item unity
C#Unity
14 votes175 views1 answer
Unity string split
C#
1 vote178 views1 answer
Audiomixer get float
C#
-1 vote200 views1 answer
Strinng.indexOf c#
C#
1 vote166 views2 answers
SQLite in Xamarin forms
C#
1 vote235 views1 answer
Unity image
C#Unity
0 vote183 views1 answer
C# one dimensional dictionary
C#