public static async Task QueryAsync(
IDataContext dataContext,
string?tableName,
string?serverName,
string?databaseName,
string?schemaName,
bool?ifExists,
TableOptions tableOptions,
CancellationToken token)
{
var sqlTable = new SqlTable <T>(dataContext.MappingSchema);
var dropTable = new SqlDropTableStatement(sqlTable);
if (tableName != null)
{
sqlTable.PhysicalName = tableName;
}
if (serverName != null)
{
sqlTable.Server = serverName;
}
if (databaseName != null)
{
sqlTable.Database = databaseName;
}
if (schemaName != null)
{
sqlTable.Schema = schemaName;
}
if (tableOptions.IsSet())
{
sqlTable.TableOptions = tableOptions;
}
sqlTable.Set(ifExists, TableOptions.DropIfExists);
var query = new Query <int>(dataContext, null)
{
Queries = { new QueryInfo {
Statement = dropTable,
} }
};
SetNonQueryQuery(query);
await query.GetElementAsync(dataContext, Expression.Constant(null), null, null, token).ConfigureAwait(Common.Configuration.ContinueOnCapturedContext);
}
public static void Query(
IDataContext dataContext,
string?tableName,
string?serverName,
string?databaseName,
string?schemaName,
bool?ifExists,
TableOptions tableOptions)
{
var sqlTable = new SqlTable <T>(dataContext.MappingSchema);
var dropTable = new SqlDropTableStatement(sqlTable);
if (tableName != null)
{
sqlTable.PhysicalName = tableName;
}
if (serverName != null)
{
sqlTable.Server = serverName;
}
if (databaseName != null)
{
sqlTable.Database = databaseName;
}
if (schemaName != null)
{
sqlTable.Schema = schemaName;
}
if (tableOptions.IsSet())
{
sqlTable.TableOptions = tableOptions;
}
sqlTable.Set(ifExists, TableOptions.DropIfExists);
var query = new Query <int>(dataContext, null)
{
Queries = { new QueryInfo {
Statement = dropTable
} }
};
SetNonQueryQuery(query);
query.GetElement(dataContext, Expression.Constant(null), null, null);
}
public static void Query(
IDataContext dataContext,
string?tableName,
string?serverName,
string?databaseName,
string?schemaName,
bool?ifExists,
TableOptions tableOptions)
{
var sqlTable = new SqlTable <T>(dataContext.MappingSchema);
var dropTable = new SqlDropTableStatement(sqlTable);
if (tableName != null || schemaName != null || databaseName != null || databaseName != null)
{
sqlTable.TableName = new(
tableName ?? sqlTable.TableName.Name,
Server : serverName ?? sqlTable.TableName.Server,
Database : databaseName ?? sqlTable.TableName.Database,
Schema : schemaName ?? sqlTable.TableName.Schema);
}
if (tableOptions.IsSet())
{
sqlTable.TableOptions = tableOptions;
}
sqlTable.Set(ifExists, TableOptions.DropIfExists);
var query = new Query <int>(dataContext, null)
{
Queries = { new QueryInfo {
Statement = dropTable
} }
};
SetNonQueryQuery(query);
query.GetElement(dataContext, ExpressionInstances.UntypedNull, null, null);
}