public static string CreateSelectCommand(string tableName, IEnumerable <string> fields, SqlFieldValuePair pair) { return($"SELECT {string.Join(",", fields)} FROM {tableName} WHERE {pair}"); }
public static string CreateUpdateCommand(string tableName, IEnumerable <SqlFieldValuePair> pairs, SqlFieldValuePair conditionPair) { return($"UPDATE {tableName} SET {string.Join(",", pairs)} WHERE {conditionPair}"); }
public static string CreateSelectCommand(string tableName, SqlFieldValuePair pair) { return($"SELECT * FROM {tableName} WHERE {pair}"); }