public DbCommand BuildCommand() { //if there are settings, need to peel off the last comma of the SET statement var cmd = db.CreateCommand(Sql); //settings foreach (var par in this.settingsQueue.Keys) { cmd.AddParameter(par, settingsQueue[par], SqlHelper.GetDbType(settingsQueue[par])); } //inserts foreach (var par in this.insertValues.Keys) { cmd.AddParameter(par, insertValues[par], SqlHelper.GetDbType(insertValues[par])); } //constraints foreach (var par in this.paramQueue.Keys) { cmd.AddParameter(par, paramQueue[par], SqlHelper.GetDbType(paramQueue[par])); } return(cmd); }
public static DbCommand ToCommand(this string sql, string connStringName) { var db = new DbCommon(connStringName); var cmd = db.CreateCommand(sql); return(cmd); }
public DbCommand BuildCommand(string connectionStringName) { var db = new DbCommon(connectionStringName); var cmd = db.CreateCommand(GetSql()); foreach (var con in DbParams) { cmd.AddParameter(con.Name, con.Value, con.DbType); } return(cmd); }