public async Task InsertCommand() { var random = new Random(); var sproc = new dboSimulatedInsertStatement() { TestInt = random.Next(), }; using (var con = new SqlConnection(connectionString)) { var executor = new Executor(con); var results = await executor.NonQuery(sproc.Build(con)); Assert.AreEqual(1, results); } }
public async Task InsertConnectitonHandedOff() { var random = new Random(); var executor = new Executor(new SqlConnection(connectionString)); for (var i = 0; i < random.Next(1000, 2000); i++) { var sproc = new dboSimulatedInsertStatement() { TestInt = random.Next(), }; var results = await executor.NonQuery(sproc); Assert.AreEqual(1, results); } }
public void TestintGetSet() { var item = new dboSimulatedInsertStatement(); var expected = new Random().Next(); item.TestInt = expected; Assert.AreEqual(expected, item.TestInt); }
public void FullyQualifiedName() { var item = new dboSimulatedInsertStatement(); Assert.AreEqual("[dbo].[SimulatedInsertStatement]", item.FullyQualifiedName()); }
public void TestintDataMapper() { var item = new dboSimulatedInsertStatement(); var property = (from prop in item.GetProperties() where prop.Name == "TestInt" select prop).FirstOrDefault(); Assert.IsNotNull(property); var mapper = property.GetAttribute<DataMapperAttribute>(); Assert.IsNotNull(mapper); Assert.AreEqual("@TestInt", mapper.ParameterName); Assert.AreEqual(DbType.Int32, mapper.DatabaseType); }
public async Task IDbCommandLoadNothing() { var random = new Random(); using (var con = new SqlConnection(connectionString)) { var sproc = new dboSimulatedInsertStatement() { TestInt = random.Next(), }; var cmd = sproc.Build(con); var loader = new Loader<SelectData>(); await con.OpenAsync(); var obj = loader.Model(cmd); Assert.IsNull(obj); } }