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 vote279 views2 answers
Should i learn c #
C#
0 vote299 views1 answer
C# i++ meaning
C#
3 votes286 views1 answer
C# dictionary first
C#
0 vote313 views4 answers
C# string to float
C#
1 vote285 views1 answer
C# datagridview hide header
C#
3 votes344 views1 answer
Unity how to load up a scene
C#Unity
-1 vote285 views4 answers
How to exit winforms application and shutdown pc in c#
C#
0 vote293 views1 answer
Data annotations in asp.net core
C#
2 votes271 views1 answer
C# get object property value by name
C#
0 vote299 views1 answer
C# draggable controls
C#