public string CreateQuery(ProcedureData data) { var sql = CreateCommand.Replace("[PROCEDURE_NAME]", data.Name); sql = sql.Replace("VARS", data.Vars); sql = sql.Replace("SCRIPT", data.Script); return(sql); }
public string CreateQuery(FunctionData data) { var sql = CreateCommand.Replace("FUNCTIONAME", data.Name); sql = sql.Replace("RETURNTYPE", data.ReturnType); sql = sql.Replace("SCRIPTO", data.Script); return(sql); }
public string CreateQuery(CheckData checkHelper) { var sql = CreateCommand.Replace("TABLENAME", checkHelper.Table); sql = sql.Replace("CHECKNAME", checkHelper.Name); sql = sql.Replace("CONDITION", checkHelper.Script); return(sql); }
public string CreateQuery(string tableName) { var sql = CreateCommand.Replace("[TABLENAME]", tableName); var start = sql.IndexOf('('); sql = sql.Insert(start + 1, ConcatColumnNames()); start = sql.LastIndexOf(");"); sql = sql.Insert(start - 1, AddConstraints()); return(sql); }