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