/// <summary> /// Execute As List /// </summary> /// <typeparam name="T"><T></typeparam> /// <param name="StroredProcedureName">Storedprocedure Name</param> /// <returns></returns> public async Task <IList <T> > ExecuteAsListAsync <T>(string StroredProcedureName) { using (SqlConnection SQLConn = new SqlConnection(this._connectionString)) { using (SqlCommand SQLCmd = new SqlCommand()) { SQLCmd.Connection = SQLConn; SQLCmd.CommandText = StroredProcedureName; SQLCmd.CommandType = CommandType.StoredProcedure; try { SqlDataReader SQLReader; await SQLConn.OpenAsync(); SQLReader = await SQLCmd.ExecuteReaderAsync(CommandBehavior.CloseConnection); //datareader automatically closes the SQL connection IList <T> mList = DataSourceHelper.FillCollection <T>(SQLReader); if (SQLReader != null) { SQLReader.Close(); } SQLConn.Close(); return(mList); } catch (Exception e) { throw e; } finally { SQLConn.Close(); } } } }
/// <summary> /// Execute As enumerable /// </summary> /// <typeparam name="T"><T></typeparam> /// <param name="StroredProcedureName">Storedprocedure Name</param> /// <returns></returns> public IEnumerable <T> ExecuteAsEnumerable <T>(string StroredProcedureName) { SqlConnection SQLConn = new SqlConnection(this._connectionString); try { SqlDataReader SQLReader; SqlCommand SQLCmd = new SqlCommand(); SQLCmd.Connection = SQLConn; SQLCmd.CommandText = StroredProcedureName; SQLCmd.CommandType = CommandType.StoredProcedure; SQLConn.Open(); SQLReader = SQLCmd.ExecuteReader(CommandBehavior.CloseConnection); //datareader automatically closes the SQL connection IEnumerable <T> mList = DataSourceHelper.FillCollection <T>(SQLReader); if (SQLReader != null) { SQLReader.Close(); } SQLConn.Close(); return(mList); } catch (Exception e) { throw e; } finally { SQLConn.Close(); } }
/// <summary> /// Execute As list /// </summary> /// <typeparam name="T"></typeparam> /// <param name="StroredProcedureName">StoreProcedure Name</param> /// <param name="ParaMeterCollection"></param> /// <returns></returns> public IList <T> ExecuteAsList <T>(string StroredProcedureName, List <SQLParam> ParaMeterCollection) { SqlConnection SQLConn = new SqlConnection(this._connectionString); try { SqlDataReader SQLReader; SqlCommand SQLCmd = new SqlCommand(); SQLCmd.Connection = SQLConn; SQLCmd.CommandText = StroredProcedureName; SQLCmd.CommandType = CommandType.StoredProcedure; SqlParameter[] sqlParameters = new SQLParamCollection(ParaMeterCollection).ParamCollection; SQLCmd.Parameters.AddRange(sqlParameters); SQLConn.Open(); SQLReader = SQLCmd.ExecuteReader(CommandBehavior.CloseConnection); //datareader automatically closes the SQL connection IList <T> mList = DataSourceHelper.FillCollection <T>(SQLReader); if (SQLReader != null) { SQLReader.Close(); } SQLConn.Close(); return(mList); } catch (Exception e) { throw e; } finally { SQLConn.Close(); } }
/// <summary> /// Execute As Object /// </summary> /// <typeparam name="T"><T></typeparam> /// <param name="StroredProcedureName">StoreProcedure Name</param> /// <param name="ParaMeterCollection">Accept Key Value Collection For Parameters</param> /// <returns></returns> public async Task <T> ExecuteAsObjectAsync <T>(string StroredProcedureName, List <SQLParam> ParaMeterCollection) { using (SqlConnection SQLConn = new SqlConnection(this._connectionString)) { using (SqlCommand SQLCmd = new SqlCommand()) { SQLCmd.Connection = SQLConn; SQLCmd.CommandText = StroredProcedureName; SQLCmd.CommandType = CommandType.StoredProcedure; SqlParameter[] sqlParameters = new SQLParamCollection(ParaMeterCollection).ParamCollection; SQLCmd.Parameters.AddRange(sqlParameters); try { SqlDataReader SQLReader; await SQLConn.OpenAsync(); SQLReader = await SQLCmd.ExecuteReaderAsync(CommandBehavior.CloseConnection); ArrayList arrColl = DataSourceHelper.FillCollection(SQLReader, typeof(T)); SQLConn.Close(); if (SQLReader != null) { SQLReader.Close(); } if (arrColl != null && arrColl.Count > 0) { return((T)arrColl[0]); } else { return(default(T)); } } catch (Exception e) { throw e; } finally { SQLConn.Close(); } } } }
/// <summary> /// Execute As Object /// </summary> /// <typeparam name="T"><T></typeparam> /// <param name="StroredProcedureName">Accept Key Value Collection For Parameters</param> /// <returns></returns> public T ExecuteAsObject <T>(string StroredProcedureName) { SqlConnection SQLConn = new SqlConnection(this._connectionString); try { SqlDataReader SQLReader; SqlCommand SQLCmd = new SqlCommand(); SQLCmd.Connection = SQLConn; SQLCmd.CommandText = StroredProcedureName; SQLCmd.CommandType = CommandType.StoredProcedure; SQLConn.Open(); SQLReader = SQLCmd.ExecuteReader(); ArrayList arrColl = DataSourceHelper.FillCollection(SQLReader, typeof(T)); SQLConn.Close(); if (SQLReader != null) { SQLReader.Close(); } if (arrColl != null && arrColl.Count > 0) { return((T)arrColl[0]); } else { return(default(T)); } } catch (Exception e) { throw e; } finally { SQLConn.Close(); } }