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