public void InsertRowsException()
{
var myCommand = new MyDalDbCommand();
using (var dal = new Dal(new MyDalDbConnection(), myCommand, new MyDalConfiguration()))
{
var coll = new List <RowObject>(new RowObject[] {
new RowObject("a1", new DateTime(2011, 1, 2))
});
try
{
dal.InsertRows(coll);
Assert.Fail("coll inserted correctly but I'm wait exception");
}
catch (DalException ex)
{
Assert.AreEqual(ex.Message, "Assert.Fail failed. Wrong parameters: a1 1/2/2011 12:00:00 AM");
}
}
}
public void InsertRows()
{
var myCommand = new MyDalDbCommand();
using (var dal = new Dal(new MyDalDbConnection(), myCommand, new MyDalConfiguration()))
{
var pars = myCommand.Parameters;
Assert.AreEqual(2, myCommand.Parameters.Count);
Assert.AreEqual("@name", ((SqlParameter)myCommand.Parameters[0]).ParameterName);
Assert.AreEqual("@date", ((SqlParameter)myCommand.Parameters[1]).ParameterName);
Assert.AreEqual(SqlDbType.VarChar, ((SqlParameter)myCommand.Parameters[0]).SqlDbType);
Assert.AreEqual(50, ((SqlParameter)myCommand.Parameters[0]).Size);
Assert.AreEqual(SqlDbType.DateTime, ((SqlParameter)myCommand.Parameters[1]).SqlDbType);
var coll = new List <RowObject>(new RowObject[] {
new RowObject("a1", new DateTime(2011, 1, 1)),
new RowObject("a2", new DateTime(2012, 2, 2))
});
dal.InsertRows(coll);
}
}
