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

3 votes138 views6 answers
C# timestamp
C#
0 vote112 views1 answer
Get mac address of Device - NAYCode.com
C#
0 vote109 views1 answer
Lamda expression multiple and
C#
1 vote99 views1 answer
Assign boolean value c#
C#
0 vote148 views1 answer
How to use navmeshagent in unity
C#Unity
2 votes105 views2 answers
Casting string to enum type
C#
0 vote99 views1 answer
Convert string to short c#
C#
0 vote101 views1 answer
Ef core include
C#
0 vote109 views1 answer
Unity stop velocity movement
C#
0 vote109 views1 answer
Unity editor window mesh field
C#