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; }
public SqlStatement(string connectionStringName) { db = new DbCommon(connectionStringName); sb = new StringBuilder(); sbSets = new StringBuilder(); sbConstraints = new StringBuilder(); sbOrderBys = new StringBuilder(); sbInserts = new StringBuilder(); this.paramQueue = new Dictionary<string, object>(); this.settingsQueue = new Dictionary<string, object>(); this.insertValues = new Dictionary<string, object>(); appendedStatements = new List<SqlStatement>(); DbParams = new List<Parameter>(); }
public static void Execute(this IEnumerable<DbCommand> commands, string connStringName) { var db=new DbCommon(connStringName); db.ExecuteTransaction(commands.ToArray()); }
public static DbCommand ToCommand(this string sql, string connStringName) { var db=new DbCommon(connStringName); var cmd=db.CreateCommand(sql); return cmd; }
public static void Execute(this SortedList<int,DbCommand> commands, string connStringName) { //using a sorted list here to allow for sequential execution var db = new DbCommon(connStringName); db.ExecuteTransaction(commands); }