/// <summary> /// Creates a raw TaskSqlCommand /// </summary> public TaskSqlCommand CreateCommand() { this.InitializeConnection(); SqlCommand cmd = this._connection.CreateCommand(); TaskSqlCommand tcmd = new TaskSqlCommand(cmd); return tcmd; }
/// <summary> /// Creates a TaskSqlCommand for a string sql command. /// </summary> /// <remarks>Avoid using this method.</remarks> public TaskSqlCommand CreateTextCommand(string commandText) { this.InitializeConnection(); SqlCommand cmd = this._connection.CreateCommand(); cmd.CommandText = commandText; cmd.CommandType = CommandType.Text; TaskSqlCommand tcmd = new TaskSqlCommand(cmd); return tcmd; }
/// <summary> /// Creates a TaskSqlCommand for a stored procedure provided /// </summary> public TaskSqlCommand CreateStoredProcCommand(string storedProcName) { this.InitializeConnection(); SqlCommand cmd = this._connection.CreateCommand(); cmd.CommandText = storedProcName; cmd.CommandType = CommandType.StoredProcedure; TaskSqlCommand tcmd = new TaskSqlCommand(cmd); return tcmd; }
public XmlReader ExecuteXmlReader(TaskSqlCommand cmd) { try { XmlReader reader = cmd.Command.ExecuteXmlReader(); return reader; } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExecuteXmlReader. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteXmlReader. {0}", ex.Message); } }
///<summary> /// Executes command and returns a single object /// </summary> public object ExecuteScalar(TaskSqlCommand cmd) { try { return cmd.Command.ExecuteScalar(); } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExecuteScalar. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteScalar. {0}", ex.Message); } }
/// <summary> /// Executes command as DataTable. For strongly typed programming model this is not recommended. /// </summary> public DataTable ExecuteDataTable(TaskSqlCommand cmd) { try { DataTable dt = new DataTable(); System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd.Command); da.Fill(dt); return dt; } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExecuteDataTable. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteDataTable. {0}", ex.Message); } }
/// <summary> /// Provides a forward-readonly access to the database. This is the fasted way to retrieve data. /// </summary> public SqlDataReader ExecuteDataReader(TaskSqlCommand cmd) { try { System.Data.SqlClient.SqlDataReader dr = cmd.Command.ExecuteReader(); return dr; } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExecuteDataReader. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteDataReader. {0}", ex.Message); } }
/// <summary> /// Creates a TaskSqlCommand for a string sql command. /// </summary> /// <remarks>Avoid using this method.</remarks> public TaskSqlCommand CreateTextCommand(string commandFormatText, params object[] args) { SqlCommand cmd = this._connectionForTransaction.CreateCommand(); cmd.CommandText = string.Format(commandFormatText, args); cmd.CommandType = CommandType.Text; TaskSqlCommand tcmd = new TaskSqlCommand(cmd, _transaction); return tcmd; }
/// <summary> /// Creates a TaskSqlCommand for a string sql command. /// </summary> /// <remarks>Avoid using this method.</remarks> public TaskSqlCommand CreateTextCommand(string commandText) { SqlCommand cmd = this._connectionForTransaction.CreateCommand(); cmd.CommandText = commandText; cmd.CommandType = CommandType.Text; TaskSqlCommand tcmd = new TaskSqlCommand(cmd, _transaction); return tcmd; }
/// <summary> /// Creates a TaskSqlCommand for a stored procedure provided /// </summary> public TaskSqlCommand CreateStoredProcCommand(string storedProcName) { SqlCommand cmd = this._connectionForTransaction.CreateCommand(); cmd.CommandText = storedProcName; cmd.CommandType = CommandType.StoredProcedure; TaskSqlCommand tcmd = new TaskSqlCommand(cmd, _transaction); return tcmd; }
/// <summary> /// Creates a raw TaskSqlCommand /// </summary> public TaskSqlCommand CreateCommand() { SqlCommand cmd = this._connectionForTransaction.CreateCommand(); TaskSqlCommand tcmd = new TaskSqlCommand(cmd, _transaction); return tcmd; }
/// <summary> /// Creates a TaskSqlCommand for a string sql command. /// </summary> /// <remarks>Avoid using this method.</remarks> public TaskSqlCommand CreateTextCommand(string commandFormatText, params object[] args) { this.InitializeConnection(); SqlCommand cmd = this._connection.CreateCommand(); cmd.CommandText = string.Format(commandFormatText, args); cmd.CommandType = CommandType.Text; TaskSqlCommand tcmd = new TaskSqlCommand(cmd); return tcmd; }
/// <summary> /// Executes command as Non Query. Best for Update/Delete operations. /// </summary> /// <returns>Number of rows affected.</returns> public int ExecuteNonQuery(TaskSqlCommand cmd) { try { int ret = cmd.Command.ExecuteNonQuery(); return ret; } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExectuteNonQuery. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteNonQuery. {0}", ex.Message); } finally { this.DisposeConnection(); } }
/// <summary> /// Executes command as DataSet. For strongly typed programming model this is not recommended. /// </summary> public DataSet ExecuteDataSet(TaskSqlCommand cmd) { try { DataSet ds = new DataSet(); System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd.Command); da.Fill(ds); return ds; } catch (SqlException sqlex) { if (sqlex.Number == 50000) { throw new UserFriendlyDBException(sqlex.Message, sqlex); } else { throw new DalException(sqlex, "SqlException occured in ExecuteDataSet. {0}", sqlex.Message); } } catch (Exception ex) { throw new DalException(ex, "Error occured in ExecuteDataSet. {0}", ex.Message); } finally { this.DisposeConnection(); } }