public async Task DataTableDictionaries()
{
using (var con = new SqlConnection(connectionString))
{
var sproc = new dboSelectMultipleStatement();
var cmd = sproc.Build(con);
var loader = new DynamicLoader();
await con.OpenAsync();
var adapter = new SqlDataAdapter(cmd);
var ds = new DataSet();
adapter.Fill(ds);
var objs = loader.Dictionaries(ds.Tables[0]);
Assert.IsNotNull(objs);
var i = 0;
foreach (var obj in objs)
{
Assert.AreEqual(i, obj["Identifier"]);
i++;
}
}
}
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 void FullyQualifiedName()
{
var item = new dboSelectMultipleStatement();
Assert.AreEqual("[dbo].[SelectMultipleStatement]", item.FullyQualifiedName());
}
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 async Task IDbCommandDynamics()
{
var sproc = new dboSelectMultipleStatement();
var loader = new DynamicLoader();
using (var con = new SqlConnection(connectionString))
{
var cmd = sproc.Build(con);
await con.OpenAsync();
var objs = loader.Dynamics(cmd);
Assert.IsNotNull(objs);
var i = 0;
foreach (var obj in objs)
{
Assert.AreEqual(i, obj.Identifier);
i++;
}
}
}