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