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 vote367 views1 answer
System.InvalidOperationException: The AuthorizationPolicy named: 'View All Roles' was not found.
C#
0 vote368 views1 answer
Unity predicts rigidbody position in x seconds
C#
0 vote376 views1 answer
Select distinct linq mvc
C#
0 vote338 views1 answer
Nunit return parameter
C#
0 vote375 views1 answer
Player not following slide object unity 2d
C#
0 vote367 views1 answer
Unity deactivate scripts in list
C#
0 vote389 views1 answer
Save binary data to file c#
C#
5 votes353 views3 answers
Ping with c#
C#
3 votes402 views1 answer
How to convert angle to vector in c#
C#
0 vote348 views1 answer
Add-migration is not recognized
C#