public void SqlReaderToModelBuilder_ValidSqlReader_ReturnCorrectStudentModel() { //Arrange var expected = RandomizerHelper.GetNewRandomStudent(); mockDataReader.Setup(x => x.GetInt32(0)).Returns(expected.Id); mockDataReader.Setup(x => x.GetString(1)).Returns(expected.Email); //Act var actual = SqlHelper.SqlReaderToModelBuilder <Student>(mockDataReader.Object); //Assert AssertStudentAreEqual(expected, actual); }
public void ModelToSqlCommandBuilder_ValidArguments_ReturnVaidSqlCommandForStudent() { //Arrange var model = RandomizerHelper.GetNewRandomStudent(); var query = RandomizerHelper.GetRandomString(); var sqlConnection = new SqlConnection(); var expected = new SqlCommand(query, sqlConnection); expected.Parameters.Add("@Id", SqlDbType.Int).Value = model.Id; expected.Parameters.Add("@Email", SqlDbType.NVarChar).Value = model.Email; //Act var actual = SqlHelper.ModelToSqlCommandBuilder <Student>(model, query, sqlConnection); //Assert AssertSqlCommandAreEqual(expected, actual); }