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 vote100 views1 answer
Asp.net mvc hide div from controller
C#
4 votes135 views1 answer
Unity get velocity of gameobject
C#Unity
1 vote116 views1 answer
Unity c# check if multiple keys are pressed
C#
8 votes100 views1 answer
Stopwatch c#
C#
0 vote103 views1 answer
How to write a ello world program in c#
C#
0 vote99 views1 answer
C# dictionnaries
C#
0 vote100 views2 answers
Get first and last item list c#
C#
0 vote102 views1 answer
Asp net img src path from database
C#
0 vote127 views1 answer
C# string code ascii
C#
0 vote103 views1 answer
Spawning object around in a circle of an gameobject unity'
C#