public static void CommentLine(ref string sql, KCore.C.Database.DBaseType type)
{
switch (type)
{
case KCore.C.Database.DBaseType.Hana:
sql = sql.Replace(C.SQLSyntax.CommentMSQL, "--"); break;
case KCore.C.Database.DBaseType.MSQL:
sql = sql.Replace(C.SQLSyntax.CommentHana, "--"); break;
default:
throw new NotImplementedException();
}
}
/// <summary>
/// Execute many actions to prepare the query.
/// </summary>
/// <param name="manipulation"></param>
/// <param name="sql"></param>
/// <param name="values"></param>
public static void Prepare(KCore.C.Database.DBaseType type, bool manipulation, ref string sql, params object[] values)
{
Factory.MyTags.CommentLine(ref sql, type);
Factory.MyTags.Namespace(ref sql);
using (var client = (IBaseClient)Activator.CreateInstance(_client, new object[] { true }))
{
switch (client.DataInfo.DBaseType)
{
case KCore.C.Database.DBaseType.MSQL: DB.Scripts.MSQLFix.Format(ref sql, values, manipulation); break;
case KCore.C.Database.DBaseType.Hana: DB.Scripts.HanaFix.Format(ref sql, values, manipulation); break;
default: throw new NotImplementedException();
}
}
}
