public void Update(TableInfo info)
{
if (TableName == null)
{
TableName = info.Table;
}
else
{
info.Table = TableName;
}
var auto = Columns.Find(d => d.IsIdentity);
if (auto != null)
{
info.IdentityColumn = auto.PropertyName;
}
}
public void DropTableIfExists(DbConnection db, TableName table)
{
var name = _utils.EscapeTableName(table);
db.Execute($"IF OBJECT_ID('{name}', 'U') IS NOT NULL DROP TABLE {name}");
}
public bool TableExists(DbConnection cnx, TableName table)
{
var name = _utils.EscapeTableName(table);
return cnx.GetValue<int?>(c => c.Sql($"select OBJECT_ID (N'{name}', N'U')")).HasValue;
}
public void DropTableIfExists(DbConnection db, TableName table)
{
db.Execute($"drop table if exists {_utils.EscapeTableName(table)}");
}
public bool TableExists(DbConnection cnx, TableName table)
{
return cnx.GetValue<bool?>($"SELECT 1 FROM sqlite_master WHERE type='table' AND name=@0", table.Name)??false;
}
public string EscapeTableName(TableName table)
{
table.Name.MustNotBeEmpty();
return table.Name;
}