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 vote218 views1 answer
C# class responsible for creating instances
C#
0 vote272 views2 answers
ExecuteResultAsync ActionContext statuscode
C#
0 vote198 views2 answers
Jquery: return true or false if the element is present in the DOM or not
C#
0 vote190 views1 answer
Selecteditem treeview wpf
C#
0 vote214 views1 answer
Ioptions mock c# unittest
C#
0 vote182 views1 answer
C# an object on upper level cannot be added to an object
C#
0 vote191 views1 answer
Get tree node godot
C#
0 vote208 views1 answer
Show double in textbox c#
C#
0 vote222 views1 answer
Get name of project c# .net
C#
53 votes186 views6 answers
Print in c#
C#