public static async Task CreateAndAddRows()
{
var tableInfo = new TableInfo(new ObjectName("table1"));
tableInfo.Columns.Add(new ColumnInfo("a", PrimitiveTypes.Integer()));
tableInfo.Columns.Add(new ColumnInfo("b", PrimitiveTypes.VarChar(22)));
var table = new TemporaryTable(tableInfo);
table.AddRow(new SqlObject[] {
SqlObject.Integer(22),
SqlObject.String(new SqlString("test")),
});
Assert.Equal(1, table.RowCount);
var value1 = await table.GetValueAsync(0, 0);
var value2 = await table.GetValueAsync(0, 1);
Assert.Equal(SqlObject.Integer(22), value1);
Assert.Equal(SqlObject.String(new SqlString("test")), value2);
}
public static async Task SetRowValues()
{
var tableInfo = new TableInfo(new ObjectName("table1"));
tableInfo.Columns.Add(new ColumnInfo("a", PrimitiveTypes.Integer()));
tableInfo.Columns.Add(new ColumnInfo("b", PrimitiveTypes.VarChar(22)));
var table = new TemporaryTable(tableInfo);
var row = table.NewRow();
table.SetValue(row, 0, SqlObject.Integer(45));
table.SetValue(row, 1, SqlObject.String(new SqlString("992")));
Assert.Equal(1, table.RowCount);
var value1 = await table.GetValueAsync(0, 0);
Assert.Equal(SqlObject.Integer(45), value1);
}
