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