public override IList <DatabaseConstraint> CheckConstraints(string tableName)
{
var dt = _schemaReader.CheckConstraints(tableName);
var converter = new SchemaConstraintConverter(dt, ConstraintType.Check);
return(converter.Constraints());
}
public SchemaConstraintLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var pks = _sr.PrimaryKeys(null);
_noPks = (pks.Rows.Count == 0);
if (!_noPks)
{
_pkConverter = new SchemaConstraintConverter(pks, ConstraintType.PrimaryKey);
}
var fks = _sr.ForeignKeys(null);
_noFks = (fks.Rows.Count == 0);
if (!_noFks)
{
_fkConverter = new SchemaConstraintConverter(fks, ConstraintType.ForeignKey);
}
//foreign key columns
var fkcols = _sr.ForeignKeyColumns(null);
_fkColumnConverter = new ForeignKeyColumnConverter(fkcols);
var uks = _sr.UniqueKeys(null);
_ukConverter = new SchemaConstraintConverter(uks, ConstraintType.UniqueKey);
var cks = _sr.CheckConstraints(null);
_ckConverter = new SchemaConstraintConverter(cks, ConstraintType.Check);
var dfs = _sr.DefaultConstraints(null);
_dfConverter = new SchemaConstraintConverter(dfs, ConstraintType.Default);
}
public SchemaConstraintLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var pks = _sr.PrimaryKeys(null);
_noPks = (pks.Rows.Count == 0);
if (!_noPks)
{
_pkConverter = new SchemaConstraintConverter(pks, ConstraintType.PrimaryKey);
}
var fks = _sr.ForeignKeys(null);
_noFks = (fks.Rows.Count == 0);
if (!_noFks)
{
_fkConverter = new SchemaConstraintConverter(fks, ConstraintType.ForeignKey);
}
//foreign key columns
var fkcols = _sr.ForeignKeyColumns(null);
_fkColumnConverter = new ForeignKeyColumnConverter(fkcols);
var uks = _sr.UniqueKeys(null);
_ukConverter = new SchemaConstraintConverter(uks, ConstraintType.UniqueKey);
var cks = _sr.CheckConstraints(null);
_ckConverter = new SchemaConstraintConverter(cks, ConstraintType.Check);
var dfs = _sr.DefaultConstraints(null);
_dfConverter = new SchemaConstraintConverter(dfs, ConstraintType.Default);
}
