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

2 votes208 views2 answers
Rotation unity script 2d
C#
0 vote189 views1 answer
Precision comparison in C#
C#
0 vote171 views1 answer
Unity sprite blurry when far
C#
2 votes192 views1 answer
Json ignore property c#
C#
0 vote242 views2 answers
FiveM pc key code
C#
0 vote186 views1 answer
"The reference assemblies for .NETFramework,Version=v6.0 were not found"
C#
5 votes190 views1 answer
C# make request to rest api
C#
2 votes203 views2 answers
Inactive after active with press key unity
C#
2 votes172 views2 answers
Binary tree
C#
0 vote178 views1 answer
Index was out of the bound array in c#
C#