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