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