public ConstraintDefinition SetPrimaryKey(string columnsNames, string keyName = null)
{
columnsNames.MustNotBeEmpty();
if (keyName == null) keyName = "PK_" + _table.TableName.FilterEscape();
PrimaryKey = new UniqueKeyConstraint {Name = keyName, Columns = columnsNames, IsPrimary = true};
return PrimaryKey;
}
public ConstraintDefinition AddUnique(string columns, string name = null)
{
columns.MustNotBeEmpty();
if (name == null) name = GenerateIndexName(columns);
var uc = new UniqueKeyConstraint {Name = name, Columns = columns};
Uniques.Add(uc);
return uc;
}
public ConstraintDefinition SetPrimaryKey(string columnsNames, string keyName = null)
{
columnsNames.MustNotBeEmpty();
if (keyName == null)
{
keyName = "PK_" + _table.TableName.FilterEscape();
}
PrimaryKey = new UniqueKeyConstraint {
Name = keyName, Columns = columnsNames, IsPrimary = true
};
return(PrimaryKey);
}
public ConstraintDefinition AddUnique(string columns, string name = null)
{
columns.MustNotBeEmpty();
if (name == null)
{
name = GenerateIndexName(columns);
}
var uc = new UniqueKeyConstraint {
Name = name, Columns = columns
};
Uniques.Add(uc);
return(uc);
}
public virtual void Write(UniqueKeyConstraint constraint)
{
base.Write(constraint);
}
public UniqueKeyWriterTests()
{
_sb = new StringBuilder();
_key = new UniqueKeyConstraint() {Columns = "id, user name",Name = "PK_Id",IsPrimary = true};
_writer = new SqlServerUniqueKeyWriter(_sb);
}