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 vote141 views1 answer
Unity set parent canvas
C#
0 vote140 views2 answers
How to find current country c#
C#
0 vote150 views1 answer
Get path revit link unloaded
C#
0 vote95 views1 answer
Vb.net convert int32 into boolean array stack overflow
C#
13 votes171 views6 answers
C# func
C#
0 vote140 views1 answer
Asp.net core user.identity.name is null
C#
0 vote133 views1 answer
Linq query to fetch parent child data from same table in c#
C#
0 vote189 views1 answer
Gravity script unity
C#Unity
38 votes157 views3 answers
Get mouse position unity
C#
0 vote168 views2 answers
Create viewport revit api
C#