public void TestCommandWithExpandoObjectParameters()
{
string returnValue = null;
using (var conn = new CfConnection(ConnName))
{
var cmd = conn.CreateCfCommand();
var paramters = new ExpandoObject() as IDictionary <string, object>;
paramters.Add("login", "andersonn");
DbDataReader result = (DbDataReader)cmd.ExecuteReader(CfCommandType.Text,
@"select *
from(select 'user1' as login) as t
where login = '******'",
paramters);
if (result.Read())
{
returnValue = result["login"].ToString();
}
}
Assert.AreEqual(returnValue, "user1");
}
public void TestCommandWithDynamicParameters()
{
string returnValue = null;
using (var conn = new CfConnection(ConnName))
{
var cmd = conn.CreateCfCommand();
DbDataReader result = (DbDataReader)cmd.ExecuteReader(CfCommandType.Text,
@"select *
from(select 'user1' as login) as t
where login = '******'",
new { login = "******" });
if (result.Read())
{
returnValue = result["login"].ToString();
}
}
Assert.AreEqual(returnValue, "user1");
}
