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

10 votes316 views4 answers
C# last char in string
C#
0 vote305 views3 answers
Convert getdate to ist c#
C#
1 vote314 views1 answer
InvalidOperationException: Calling Scene Raisefrom assembly reloading callbacks are not supported.
C#
1 vote295 views1 answer
C# list remove duplicate items
C#
0 vote296 views1 answer
Circle button android
C#
1 vote295 views1 answer
Unity put children in list
C#Unity
0 vote299 views1 answer
Checking if a list contains a value unity
C#
9 votes293 views2 answers
Exit button unity code
C#
0 vote317 views1 answer
Upgrade asp.net core to 5.0
C#
24 votes326 views3 answers
String to date vb
C#