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

71 votes413 views3 answers
How to loop through a list
C#
1 vote329 views1 answer
How to create empty ui object unity
C#
1 vote370 views1 answer
C# unity follow object
C#Unity
0 vote323 views1 answer
Replace first occurrence of character in string c#
C#
27 votes336 views6 answers
Stack over flow
C#
0 vote326 views1 answer
C# remove exit icon
C#
1 vote393 views1 answer
C# unity detect any keyboard input but not mouse input
C#Unity
0 vote378 views1 answer
Ef core add OnModelCreating foreign key
C#
1 vote306 views1 answer
Unity c# how to restart the level
C#
0 vote319 views1 answer
Rock paper scissors c#
C#