public DbParameterEnumerator(DbParameterCollection m) { this.m = m; }
internal String DebugQuery(String source, String command, DbParameterCollection parameters, Object transaction) { return(DebugQuery(source, command, parameters, transaction, false)); }
internal String DebugQuery(String source, String command, DbParameterCollection parameters, Object transaction, Boolean force) { if (!i_debug && !force) { return(""); } String debug = "/****** Source: " + source + " Script Date: " + DateTime.Now.ToString("yyyy-mm-dd HH:mm:ss.ffffff") + " ******/" + Environment.NewLine; if (parameters != null) { foreach (DbParameter par in parameters) { debug += "DECLARE " + par.ParameterName + " " + par.Type.ToString(); if (par.Size > 0) { debug += "(" + par.Size + ")"; } debug += Environment.NewLine; switch (par.Type.ToString().ToLower()) { case "int64": case "long": case "int32": case "int": case "int16": debug += "SET " + par.ParameterName + " = " + par.Value + Environment.NewLine; break; case "boolean": case "bool": debug += "SET " + par.ParameterName + " = " + ((Boolean)par.Value ? "1" : "0") + Environment.NewLine; break; default: debug += "SET " + par.ParameterName + " = '" + par.Value + "'" + Environment.NewLine; break; } } debug += Environment.NewLine; } debug += command + Environment.NewLine; debug += "GO" + Environment.NewLine + Environment.NewLine; if (!i_debug) { return(debug); } DbParameterCollection col = new DbParameterCollection(); col.Add("@text", typeof(String)).Value = debug; try { ExecuteNonQuery("insert into debug (text) values (@text)", CommandType.Text, col, transaction); } catch { } return(debug); }
public abstract void ExecuteNonQuery(String command, CommandType commandType, DbParameterCollection parameters, Object transaction);
internal String DebugQuery(String source, String command, DbParameterCollection parameters) { return(DebugQuery(source, command, parameters, null, false)); }
public DataTable Select(String command, CommandType commandType, DbParameterCollection parameters, Object transaction) { return(ExecuteDataTable(command, commandType, parameters, transaction)); }
public void ExecuteNonQuery(String command, CommandType commandType, DbParameterCollection parameters) { ExecuteNonQuery(command, commandType, parameters, null); }
public DataTable Select(String command, CommandType commandType, DbParameterCollection parameters) { return(ExecuteDataTable(command, commandType, parameters, null)); }
public abstract DataTable ExecuteDataTable(String command, CommandType commandType, DbParameterCollection parameters, Object transaction);
public DataTable ExecuteDataTable(String command, DbParameterCollection parameters) { return(ExecuteDataTable(command, CommandType.Text, parameters, null)); }
public abstract T ExecuteScalar <T>(String command, CommandType commandType, DbParameterCollection parameters, Object transaction);
public T ExecuteScalar <T>(String command, CommandType commandType, DbParameterCollection parameters) { return(ExecuteScalar <T>(command, commandType, parameters, null)); }