/// <summary>
/// Column should have unique values. Only one row with null value should be accepted (default for most known database engines).
/// </summary>
/// <param name="expression">The expression to set this option for</param>
/// <param name="nullsAreDistinct"><c>true</c> when nulls should be distinct</param>
/// <returns>The <paramref name="expression"/></returns>
public static ICreateIndexColumnUniqueOptionsSyntax NullsDistinct(
this ICreateIndexColumnUniqueOptionsSyntax expression,
bool nullsAreDistinct = true)
{
expression.CurrentColumn.AdditionalFeatures[IndexColumnNullsDistinct] = nullsAreDistinct;
return(expression);
}
/// <summary>
/// Column should have unique values, but multiple rows with null values should be accepted.
/// </summary>
/// <param name="expression">The expression to set this option for</param>
/// <returns>The <paramref name="expression"/></returns>
public static ICreateIndexColumnUniqueOptionsSyntax NullsNotDistinct(
this ICreateIndexColumnUniqueOptionsSyntax expression)
{
return(NullsDistinct(expression, false));
}
