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 vote133 views1 answer
How to create a random vector2 in unity
C#
12 votes120 views2 answers
How to make an object move in unity
C#
3 votes131 views1 answer
Ontriggerenter
C#
0 vote133 views1 answer
Audio source pause unity
C#
0 vote164 views1 answer
Use raycast unity new input system
C#Unity
0 vote127 views1 answer
C# make file writable
C#
1 vote93 views2 answers
Dotween sequence wait
C#
0 vote137 views2 answers
DWGExportOptions
C#
6 votes119 views1 answer
Convert int to double c#
C#
0 vote123 views4 answers
How get the user show mvc controller core 3.1
C#