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