public void AddParametersToCommand()
{
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
var command = factory.CreateCommand();
//
var condition = Check.Op("a", 10).Or(Check.Op("a", 20)).Or(Check.Op("b", 30)).Or(Check.Op("b", 40));
DbHelper.AddConditionParametersToCommand(command, condition, new SqlQueryService());
Assert.AreEqual(4, command.Parameters.Count);
Assert.AreEqual("@a", command.Parameters[0].ParameterName);
Assert.AreEqual(10, command.Parameters[0].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[0].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[0].DbType);
Assert.AreEqual("@a2", command.Parameters[1].ParameterName);
Assert.AreEqual(20, command.Parameters[1].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[1].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[1].DbType);
Assert.AreEqual("@b", command.Parameters[2].ParameterName);
Assert.AreEqual(30, command.Parameters[2].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[2].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[2].DbType);
Assert.AreEqual("@b2", command.Parameters[3].ParameterName);
Assert.AreEqual(40, command.Parameters[3].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[3].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[3].DbType);
}
public void AddConditionParametersToCommand()
{
var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
var command = factory.CreateCommand();
DbHelper.AddConditionParametersToCommand(command, Check.Op("Id", 1).And(Check.Op("RoleId", 5)), new SqlQueryService());
Assert.AreEqual(2, command.Parameters.Count);
Assert.AreEqual("@id", command.Parameters[0].ParameterName);
Assert.AreEqual(1, command.Parameters[0].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[0].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[0].DbType);
Assert.AreEqual("@roleid", command.Parameters[1].ParameterName);
Assert.AreEqual(5, command.Parameters[1].Value);
Assert.AreEqual(ParameterDirection.Input, command.Parameters[1].Direction);
Assert.AreEqual(DbType.Int32, command.Parameters[1].DbType);
}
