public void Test_Should_Generate_InlineUpdate()
{
var cmd = new MySqlCommand("update ex8db1.ATeam SET first_name=@param1 where last_name=@whereparam1", null);
cmd.Parameters.Add(new MySqlParameter("@param1", "Charlotte"));
cmd.Parameters.Add(new MySqlParameter("@whereparam1", "Saunders"));
cmd.CommandType = CommandType.Text;
var expectedSQl =
"update ex8db1.ATeam SET first_name=N'Charlotte' where last_name=N'Saunders'";
var sqlCommandStringBuilder = new MySqlCommandStringBuilder();
var result = sqlCommandStringBuilder.GetCommandTextInline(cmd);
Assert.NotEmpty(result);
Assert.Equal(expectedSQl.Replace("\n", "").Replace("\r", ""), result.Replace("\n", "").Replace("\r", ""));
}
public void Test_Should_Generate_SQL()
{
var cmd = new MySqlCommand("GetEntity", null);
cmd.Parameters.Add(new MySqlParameter("@foobar", 1));
cmd.Parameters.Add(new MySqlParameter()
{
ParameterName = "@outParam",
Direction = ParameterDirection.Output,
MySqlDbType = MySqlDbType.Int32
});
cmd.Parameters.Add(new MySqlParameter()
{
Direction = ParameterDirection.ReturnValue
});
cmd.CommandType = CommandType.StoredProcedure;
var sqlCommandStringBuilder = new MySqlCommandStringBuilder();
var sql = sqlCommandStringBuilder.GetCommandText(cmd);
Assert.NotEmpty(sql);
}
