public void IdToSqlCommandBuilder_QueryIsWhiteSpace_ThrowArgumentNullException() { //Arrange var id = RandomizerHelper.GetRandomInt(); var query = " "; var sqlConnection = new SqlConnection(); //Act + Assert Assert.Throws <ArgumentNullException>(() => SqlHelper.IdToSqlCommandBuilder(id, query, sqlConnection)); }
public void IdToSqlCommandBuilder_SqlConnectionIsNull_ThrowArgumentNullException() { //Arrange var id = RandomizerHelper.GetRandomInt(); var query = RandomizerHelper.GetRandomString(); var sqlConnection = default(SqlConnection); //Act + Assert Assert.Throws <ArgumentNullException>(() => SqlHelper.IdToSqlCommandBuilder(id, query, sqlConnection)); }
private int TryGetSeed() { try { var seed = Int32.Parse(textboxSeed.Text); return(seed == -1 ? RandomizerHelper.GetRandomInt() : seed); } catch { return(RandomizerHelper.GetRandomInt()); } }
public void IdToSqlCommandBuilder_ValidArguments_ReturnValidSqlCommand() { //Arrange var id = RandomizerHelper.GetRandomInt(); var query = RandomizerHelper.GetRandomString(); var sqlConnection = new SqlConnection(); var expected = new SqlCommand(query); expected.Parameters.Add("@Id", SqlDbType.Int).Value = id; //Act var actual = SqlHelper.IdToSqlCommandBuilder(id, query, sqlConnection); //Assert AssertSqlCommandAreEqual(expected, actual); }