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++; } } }