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

23 votes268 views4 answers
C# Base64 Encode
C#
0 vote244 views1 answer
C# get property using string
C#
0 vote253 views1 answer
How to add to a list only items that are not already in the list c#
C#
0 vote263 views1 answer
Create Generic Method
C#
0 vote248 views1 answer
C# get a value from value tuple list
C#
0 vote259 views3 answers
Enable cors asp.net mvc
C#
0 vote297 views1 answer
Jaro–winkler distance c#
C#
43 votes196 views2 answers
How to change the scale of an object in unity
C#
0 vote296 views1 answer
Checking if a list contains a value unity
C#Unity
1 vote255 views1 answer
C# winforms textbox cursor position
C#