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 vote329 views1 answer
C# loop through repeater items
C#
1 vote375 views1 answer
Function in c# to do addition
C#
31 votes353 views4 answers
C# string to datetime
C#
0 vote353 views1 answer
Ioptions mock c# unittest
C#
0 vote340 views2 answers
Unity list get item at index
C#
0 vote338 views1 answer
Belgium 251 PRG Prac
C#
3 votes334 views1 answer
How to remove last 3 characters from string in c#
C#
0 vote364 views2 answers
Autoit console write
C#
3 votes352 views1 answer
Exit a method c#
C#
2 votes284 views1 answer
Sconvert string to title case + C3
C#