/// <summary> /// Executes the data set. /// </summary> /// <param name="procedureName">Name of the procedure.</param> /// <param name="dataSetContainer">The data set container.</param> /// <param name="sqlParameters">The SQL parameters.</param> /// <exception cref="System.NullReferenceException">dataSetContainer</exception> public void ExecuteDataSet(string procedureName, DataSet dataSetContainer, List <SqlParameter> sqlParameters = null) { dataSetContainer.CheckNullObject(nameof(dataSetContainer)); using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand)) { sqlCommand.CommandText = procedureName; sqlCommand.Parameters.Clear(); sqlCommand.CommandTimeout = timeoutMillSeconds; if (sqlParameters != null) { sqlCommand.Parameters.AddRange(sqlParameters.ToArray()); } if (sqlConnection.State != ConnectionState.Open) { sqlConnection.Open(); } sqlDataAdapter.Fill(dataSetContainer); } }