public async Task Tables()
{
var loader = new Loader<Schema>();
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
var cmd = connection.CreateCommand();
cmd.CommandText = Statements.Tables;
var models = loader.Models(cmd);
Assert.IsNotNull(models);
Assert.AreEqual(20, models.Count());
foreach (var schema in models)
{
Assert.AreEqual("dbo", schema.Preface);
Assert.IsTrue(schema.Name == "LotsOfStuff" || schema.Name == "DualPrimaryKeys");
}
}
}
public async Task StoredProcedures()
{
var loader = new Loader<Schema>();
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
var cmd = connection.CreateCommand();
cmd.CommandText = Statements.StoredProcedures;
var models = loader.Models(cmd);
Assert.IsNotNull(models);
Assert.AreEqual(16, models.Count());
foreach (var schema in models)
{
Assert.AreEqual("dbo", schema.Preface);
Assert.AreEqual("ManyTypes", schema.Name);
}
}
}
public async Task ReaderModels()
{
using (var con = new SqlConnection(connectionString))
{
var sproc = new dboSelectMultipleStatement();
var cmd = sproc.Build(con);
await con.OpenAsync();
var reader = await cmd.ExecuteReaderAsync();
var loader = new Loader<SelectData>();
var objs = loader.Models(reader);
Assert.IsNotNull(objs);
var i = 0;
foreach (var obj in objs)
{
Assert.AreEqual(i, obj.Identifier);
i++;
}
}
}
public async Task DataSetModels()
{
using (var con = new SqlConnection(connectionString))
{
var sproc = new dboSelectMultipleStatement();
var cmd = sproc.Build(con);
var loader = new Loader<SelectData>();
await con.OpenAsync();
var adapter = new SqlDataAdapter(cmd);
var ds = new DataSet();
adapter.Fill(ds);
var objs = loader.Models(ds);
Assert.IsNotNull(objs);
var i = 0;
foreach (var obj in objs)
{
Assert.AreEqual(i, obj.Identifier);
i++;
}
}
}
public void ModelsDataTableNull()
{
var l = new Loader<object>();
l.Models((DataTable)null);
}
public void ModelsDataSetNull()
{
var l = new Loader<object>();
l.Models((DataSet)null);
}
public void ModelsIDataReaderNull()
{
var l = new Loader<object>();
l.Models((IDataReader)null);
}
public void ModelsIDbCommandNull()
{
var l = new Loader<object>();
l.Models((IDbCommand)null);
}
