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