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 vote113 views3 answers
Convert string into float C#
C#
2 votes113 views1 answer
Unable to resolve service for type 'Microsoft.AspNetCore.Identity.UserManager
C#
10 votes120 views3 answers
Get number of days between two dates c#
C#
10 votes114 views4 answers
C# round double
C#
0 vote136 views1 answer
Select multiple items in listview WPF
C#
0 vote113 views1 answer
C# stringwriter encoding iso-8859-1 example
C#
0 vote152 views1 answer
Moving camera with touch screen unity
C#
21 votes108 views2 answers
Change scale of an object unity
C#
1 vote109 views1 answer
How do i destroy a prefab without the error?
C#
1 vote86 views1 answer
Unity put children in list
C#Unity