public UpdateTableBuilder(IExecuteCustomSql executor, IGenerateSqlFromExpressions writer, IEscapeIdentifier utils, HelperOptions options)
{
_executor = executor;
_writer = writer;
_utils = utils;
_options = options;
_sb.Append($"update {utils.EscapeTableName(options.TableName)} set ");
}
public void DropTableIfExists(DbConnection db, TableName table)
{
db.Execute($"drop table if exists {_utils.EscapeTableName(table)}");
}
public string EscapeName(IEscapeIdentifier provider, TableName name = null)
{
name = name ?? TableName;
return(provider.EscapeTableName(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 string EscapeName(IEscapeIdentifier provider,TableName name=null)
{
name = name ?? Table;
return provider.EscapeTableName(name);
}
