public void ExecNonQuery() { string sqlConnectionString = string.Empty; if (SqlTimeOut > 0) { sqlConnectionString = BasicEntity.ConnectionString + ";Connection Timeout=" + SqlTimeOut.ToString(); } else { sqlConnectionString = BasicEntity.ConnectionString; } if (Parameters.Count > 0) { SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName, Parameters.ToArray()); } else { SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName); } }
public SqlDataReader ExecReader() { string sqlConnectionString = string.Empty; if (SqlTimeOut > 0) { sqlConnectionString = BasicEntity.ConnectionString + ";Connection Timeout=" + SqlTimeOut.ToString(); } else { sqlConnectionString = BasicEntity.ConnectionString; } if (this.Parameters.Count > 0) { return(SqlHelper.ExecuteReader(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName, Parameters.ToArray())); } else { return(SqlHelper.ExecuteReader(sqlConnectionString, CommandType.StoredProcedure, this.storedProcedureName)); } }