public int ExecuteNonQuery(QueryParameter queryParam) { this.Open(); SqlCommand command = new SqlCommand(queryParam.commandText); command.Connection = _connection; command.Parameters.AddRange(queryParam.parameters.ToArray()); int rowCount=0; try { rowCount = command.ExecuteNonQuery(); } catch (SqlException) { throw; } finally{ command.Dispose(); this.Close(); } return rowCount; }
public SqlDataReader ExecuteReader(QueryParameter queryParam) { this.Open(); SqlCommand command = new SqlCommand(queryParam.commandText); command.Connection = _connection; command.Parameters.AddRange(queryParam.parameters.ToArray()); SqlDataReader reader; try { reader = command.ExecuteReader(); } catch (SqlException) {throw;} finally { command.Dispose(); } return reader; }