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 vote264 views1 answer
How to add a ddos api to a c# console app
C#
2 votes279 views1 answer
Winforms messagebox with button
C#
2 votes279 views1 answer
SieveOfEratosthenes
C#
0 vote322 views1 answer
What is string args in c#
C#
0 vote296 views1 answer
SonarQube UnitTests
C#
8 votes266 views2 answers
C# assign if null
C#
0 vote259 views1 answer
How to print a word in C#
C#
0 vote277 views1 answer
Dadar pincode
C#
7 votes265 views2 answers
C# how to check string is number
C#
0 vote326 views3 answers
Useinmemorydatabase not found c#
C#