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 vote111 views1 answer
Hwo to prevent rotation after hitting an object in unity
C#
0 vote229 views1 answer
If file exist rename c#
C#
1 vote173 views2 answers
Append 2 arrays c#
C#
32 votes160 views10 answers
Translate
C#
-1 vote163 views1 answer
C# current thread id
C#
0 vote158 views2 answers
How to find the text position in excel in c#
C#
0 vote165 views1 answer
Autoclicker for yes/no in c# indicator
C#
0 vote160 views1 answer
Unity agent look at
C#
1 vote161 views1 answer
Randomize through array in C#
C#
0 vote185 views1 answer
Unity I run exe second monitor
C#