internal static void Execute(string tableName, string columns, string values) { StringBuilder query = new StringBuilder(); query.Append($"INSERT INTO {tableName} ({columns}) "); query.Append($"VALUES({values});"); SqlCommandExecuteQuery.Execute(query.ToString()); }
internal static void Execute(string tableName, string uuid) { StringBuilder query = new StringBuilder(); query.Append($"DELETE FROM {tableName} "); query.Append($"WHERE uuid = '{uuid}'"); SqlCommandExecuteQuery.Execute(query.ToString()); }
internal static void Execute(string tableName, int id, string columnsAndValues) { StringBuilder query = new StringBuilder(); query.Append($"UPDATE {tableName} "); query.Append($"SET {columnsAndValues} "); query.Append($"WHERE id={id};"); SqlCommandExecuteQuery.Execute(query.ToString()); }