/// <summary> /// Create an object with a SqlDataReader created from the SqlCommand /// passed. The SqlConnection object from that SqlCommand will be returned /// to the specified ConnectionPool when Dispose() is called on the enumerator. /// </summary> /// <param name="cmd"></param> /// <param name="connectionPool"></param> protected SqlEnumerator(SqlCommand cmd, PooledConnection pooledCon) { mConnection = cmd.Connection; mReader = cmd.ExecuteReader(); mPooledCon = pooledCon; mCurrent = null; mDisposed = false; }
public static SqlCommand CreateProc(string procName, PooledConnection pooledCon) { SqlCommand cmd = new SqlCommand(procName, pooledCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 60 * 60; return(cmd); }
public static SqlDataAdapter CreateSelectAdapter(string procName, PooledConnection pooledCon) { SqlCommand cmd = SqlHelper.CreateProc(procName, pooledCon); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; return(adapter); }
public void ExecuteNonQuery(string procName, AddSqlParametersDelegate addParams) { using (PooledConnection pooledCon = GetPooledConnection()) { using (SqlCommand cmd = SqlHelper.CreateProc(procName, pooledCon)) { addParams(cmd); cmd.ExecuteNonQuery(); } } }
public virtual void Delete(TPersistable entity) { using (PooledConnection pooledCon = GetPooledConnection()) { using (SqlCommand cmd = SqlHelper.CreateProc("dbo.Delete" + EntityName, pooledCon)) { SqlHelper.AddParamInputId(cmd, EntityIdVarName, entity.GetIdValue()); cmd.ExecuteNonQuery(); } } }
public virtual void Insert(TPersistable entity) { using (PooledConnection pooledCon = GetPooledConnection()) { using (SqlCommand cmd = SqlHelper.CreateProc("dbo.Insert" + EntityName, pooledCon)) { SqlParameter param = SqlHelper.AddParamOutputId(cmd, EntityIdVarName); AddInsertUpdateParams(cmd, entity); cmd.ExecuteNonQuery(); entity.SetIdValue((int)param.Value); } } }
public List <TPersistable> Search(string procName, AddSqlParametersDelegate addParams) { using (PooledConnection pooledCon = GetPooledConnection()) { using (SqlDataAdapter adapter = SqlHelper.CreateSelectAdapter(procName, pooledCon)) { using (adapter.SelectCommand) { addParams(adapter.SelectCommand); return(CreateEntities(adapter)); } } } }
public virtual TPersistable Get(TId id) { using (PooledConnection pooledCon = GetPooledConnection()) { using (SqlDataAdapter adapter = SqlHelper.CreateSelectAdapter( "dbo.Get" + EntityName, pooledCon)) { using (adapter.SelectCommand) { SqlHelper.AddParamInputId(adapter.SelectCommand, EntityIdVarName, id.Value); return(CreateEntities(adapter)[0]); } } } }