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 vote191 views1 answer
C# reflection
C#
6 votes190 views4 answers
Increment laravel
C#
0 vote210 views1 answer
Unity I run exe second monitor
C#
10 votes222 views5 answers
C# null check
C#
0 vote291 views1 answer
Unity get prefabs from folder
C#Unity
0 vote191 views1 answer
Save file with unique name c#
C#
17 votes194 views4 answers
C# remove spaces from string
C#
1 vote182 views4 answers
C# timestamp now
C#
0 vote186 views1 answer
Unity animation missing gameobject replace
C#Unity
59 votes239 views3 answers
C# date format
C#