private CreateTableExpression GetCreateTableExpression()
{
return(QueryExpression.CreateTable(
_entityModel.Table.TableName,
GetAllLocalColumns().ToArray()
));
}
public static async Task <TemporaryTestTable> CreateDataTable(SqlDataType sqlDataType, IDataProvider dataProvider)
{
var tableName = $"DataTestTable_{sqlDataType.BaseType}";
await dataProvider.ExecuteNonQueryAsync(QueryExpression.CreateTable(
tableName,
QueryExpression.DefineColumn("Data", sqlDataType)
));
return(new TemporaryTestTable(tableName, dataProvider));
}
public static async Task <TemporaryTestTable> CreateAutoIncrementTable(IDataProvider dataProvider)
{
await dataProvider.ExecuteNonQueryAsync(QueryExpression.CreateTable(
AUTOINC_TABLE_NAME,
QueryExpression.DefineColumn("Id", SqlDataType.Int(), isAutoIncrement: true, isPrimaryKey: true),
QueryExpression.DefineColumn("Data", SqlDataType.Int())
));
return(new TemporaryTestTable(AUTOINC_TABLE_NAME, dataProvider));
}
public virtual async Task CreateTable_CanCreateCompositePrimaryKey()
{
var tableName = "CreateTableTest";
using (new TemporaryTestTable(tableName, DataProvider))
{
await DataProvider.ExecuteNonQueryAsync(
QueryExpression.CreateTable(
tableName,
QueryExpression.DefineColumn("AutoId", SqlDataType.Int(), isAutoIncrement: true, isPrimaryKey: true),
QueryExpression.DefineColumn("RefId", SqlDataType.Guid(), isNullable: false, isPrimaryKey: true)
));
Assert.IsTrue(await TableExists(tableName));
}
}
public virtual async Task CreateTable_CanCreateATable()
{
var tableName = "CreateTableTest";
using (new TemporaryTestTable(tableName, DataProvider))
{
await DataProvider.ExecuteNonQueryAsync(
QueryExpression.CreateTable(
tableName,
QueryExpression.DefineColumn("Column", SqlDataType.Int())
)
);
Assert.IsTrue(await TableExists(tableName));
}
}