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

1 vote168 views1 answer
Varibles c#
C#
2 votes129 views1 answer
How to insert into a list c#
C#
1 vote142 views2 answers
C# int to bool
C#
0 vote132 views2 answers
For c#
C#
0 vote134 views1 answer
C# builder pattern fluent example
C#
0 vote140 views1 answer
Using == is inefficient unity
C#
0 vote137 views1 answer
How to make rabbitmq start and stop base on c# services
C#
5 votes186 views1 answer
If unity
C#Unity
0 vote146 views1 answer
Precision comparison in C#
C#
1 vote152 views2 answers
Hex string to int c#
C#