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 vote185 views1 answer
Convert C# Class to xml wth xsd.exe
C#
0 vote218 views1 answer
Unity random.insideunitcircle
C#Unity
0 vote188 views1 answer
Docker Test a Connection using Curl
C#
0 vote219 views1 answer
Make all variables nonserizlized unity
C#Unity
0 vote200 views1 answer
Viewstate in asp.net demo \
C#
0 vote193 views2 answers
Streamwriter c#
C#
-1 vote180 views1 answer
Populate combobox from array c#
C#
0 vote229 views1 answer
Unity get prefabs from folder
C#Unity
2 votes216 views1 answer
How to reset rotation in unity
C#Unity
0 vote205 views1 answer
Vb.net array search
C#