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 vote343 views1 answer
Get all components of type unity
C#
0 vote412 views1 answer
Unity set sprite image from script
C#Unity
0 vote333 views1 answer
C# loop 2 time tables
C#
0 vote356 views1 answer
Setting the parent of a transform which resides in a prefab
C#
1 vote423 views1 answer
C# making a folder wpf
C#
6 votes316 views3 answers
Disable rigidbody unity
C#
2 votes332 views1 answer
Add a dictionary to another dictionary c#
C#
0 vote327 views1 answer
Unity script template folder
C#
0 vote359 views1 answer
Rotate gameobject unity
C#Unity
0 vote319 views1 answer
Dotnet build command
C#