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