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 vote84 views2 answers
Get roaming folder c#
C#
0 vote96 views1 answer
How to check datagridview cell is null or empty
C#
1 vote108 views2 answers
Append 2 arrays c#
C#
0 vote116 views1 answer
True false when key pressed in c sharp unity
C#Unity
0 vote89 views1 answer
Event trigger by code unity
C#
0 vote213 views1 answer
C# create dynamic object
C#
9 votes146 views3 answers
Perlin noise unity
C#Unity
0 vote89 views3 answers
Regex check is valid ip
C#
0 vote99 views1 answer
C# for loop next iteration
C#
0 vote94 views1 answer
.net core download image from url binary file
C#