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}");
}
