MySQL view - entity mgr does not cache all recs

   I'm using this code to pull all the records from a MySQL db using a view:

var _mgr1 = new DomainModelEntityManager();

_mgr1.ExecuteQueryAsync(_mgr.vcompletedsurveydata
.Where(item => item.Created >= date)),

(fetchArgs) => { SetCasesSoldChartDataSource(fetchArgs.Result); }
, null);

For some reason this Linq query doesn't bring back all the records in the view.  I verified that the SQL sent to the db is correct and it does pull return all the records when run in a SQL query browser.  A lot of records are returned to the cache, but quite a few are missing.  Changing the Linq to the snip below brings the missing records into the cache:

var _mgr1 = new DomainModelEntityManager();

_mgr1.ExecuteQueryAsync(_mgr.vcompletedsurveydata
.Where(item => item.Created >= date)
.Where(item => item.SurveyQuestion.Contains("cases sold")),

(fetchArgs) => { SetCasesSoldChartDataSource(fetchArgs.Result); }
, null);

Any suggestions or help on what I may be doing wrong?

- Matt