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

13 votes203 views3 answers
C# get last item in list
C#
0 vote159 views1 answer
Unity rigidbody2d disable
C#
0 vote178 views1 answer
C# printwindow
C#
1 vote174 views1 answer
Get all sundays between two dates c#
C#
0 vote176 views1 answer
C# datetime remove days
C#
0 vote165 views1 answer
C# list of unique values with group and counts
C#
18 votes187 views3 answers
Get random from list c#
C#
3 votes185 views1 answer
Get type of variable c#
C#
1 vote207 views1 answer
Unity Bullet script
C#Unity
0 vote227 views1 answer
Get the current directory in unity
C#Unity