Is it my code or the Adapter failing here?

Epicor ERP 10
32

Here is the final modified code for anyone interested. I’ll mark it as solution but it was @josecgomez @danbedwards that get the credit

        public JobPartDataSet GetJob(string jobNum)
        {
            bool more;
            JobPartAdapter jpAdapter = new JobPartAdapter(oTrans);
            jpAdapter.BOConnect();
            SearchOptions opts = new SearchOptions(SearchMode.AutoSearch);
            opts.DataSetMode = DataSetMode.RowsDataSet;

            opts.PageSize = 20; //return this many
            string where = string.Format("JobNum = '{0}'", jobNum); 
            opts.NamedSearch.WhereClauses.Add("JobPart", where);
            JobPartDataSet trans = (JobPartDataSet)jpAdapter.GetRows(opts, out more);
            jpAdapter.Dispose();
            return trans;
  
        }