private static void ShowQuery(Ivony.Data.Queries.ParameterizedQuery query)
{
Console.WriteLine(query);
{
Console.WriteLine();
Console.WriteLine();
var command = new SqlParameterizedQueryParser().Parse(query);
Console.WriteLine(command.CommandText);
}
{
Console.WriteLine();
Console.WriteLine();
var command = new MySqlParameterizedQueryParser().Parse(query);
Console.WriteLine(command.CommandText);
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
}
public void ParameterSpecificationTest()
{
SqlParameterizedQueryParser.RegisterParameterSpecification(typeof(int), SqlDbType.Decimal);
Db.T($"SELECT * FROM Test1 WHERE [Index] = {0}").ExecuteNonQuery();
var command = (SqlCommand)traceService.Last().CommandObject;
Assert.AreEqual(command.Parameters[0].SqlDbType, SqlDbType.Decimal, "注册参数规范测试失败");
SqlParameterizedQueryParser.UnregisterParameterSpecification(typeof(int));
Db.T($"SELECT * FROM Test1 WHERE [Index] = {0}").ExecuteNonQuery();
command = (SqlCommand)traceService.Last().CommandObject;
Assert.AreNotEqual(command.Parameters[0].SqlDbType, SqlDbType.Decimal, "解除注册参数规范测试失败");
}
