public void AddParametersHelper_noFilter_allParametersAddedToCommand()
{
RepositoryHelper repoHelper = GetRepositoryHelper();
SqlCommand command = new SqlCommand();
TestClass testClass = new TestClass
{
Age = 15,
Name = "Bob"
};
repoHelper.AddParametersHelper(command, testClass, ParameterDirection.Input);
Assert.IsTrue(command.Parameters.Contains("@age"));
Assert.IsTrue(command.Parameters.Contains("@name"));
Assert.AreEqual(2, command.Parameters.Count);
}
public void AddParametersHelper_noFilterAndNullPropertyValue_allParametersAddedWithDBNullForNullProperty()
{
RepositoryHelper repoHelper = GetRepositoryHelper();
SqlCommand command = new SqlCommand();
TestClass testClass = new TestClass
{
Age = 15,
Name = null
};
repoHelper.AddParametersHelper(command, testClass, ParameterDirection.Input);
Assert.IsTrue(command.Parameters.Contains("@age"));
Assert.IsTrue(command.Parameters.Contains("@name"));
Assert.AreEqual(2, command.Parameters.Count);
Assert.AreEqual(DBNull.Value, command.Parameters["@name"].Value);
}
