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 vote109 views1 answer
Declarar lista c#
C#
10 votes124 views4 answers
C# last char in string
C#
11 votes168 views3 answers
C# return two values
C#
1 vote119 views1 answer
C# copy file to system folder
C#
0 vote119 views1 answer
Audio source pause unity
C#
0 vote74 views1 answer
C# clamp
C#
0 vote150 views1 answer
Billboard canvas unity
C#Unity
5 votes118 views2 answers
C# new thread
C#
3 votes119 views1 answer
What is the namespace for textmesh pro
C#
1 vote126 views1 answer
Asp core asp for not working
C#