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 vote165 views1 answer
Add qtwidgets to cmake file
C#
0 vote152 views1 answer
List clone - C#
C#
0 vote147 views1 answer
How to backup terrain in unity
C#
0 vote195 views1 answer
Unity set dictionary value
C#Unity
4 votes148 views3 answers
Sum of digit of number c#
C#
9 votes154 views3 answers
Unity get rigidbody
C#
1 vote149 views2 answers
C# environment variables
C#
4 votes143 views1 answer
Create list with values C#
C#
1 vote211 views1 answer
Unity getcomponent not working on ui
C#Unity
0 vote149 views1 answer
C# regex double of some letters only
C#