The following Linq query:
DbContext.user.Where(u => u.name.StartsWith(Text) && DbContext.invoice.FirstOrDefault(p => p.user_id == u.id) != null).ToList();
which is giving me the exception "CrossApply not implemented in Jet".
The query is working with SQL Server.
The following Linq query:
DbContext.user.Where(u => u.name.StartsWith(Text) && DbContext.invoice.FirstOrDefault(p => p.user_id == u.id) != null).ToList();
which is giving me the exception "CrossApply not implemented in Jet".
The query is working with SQL Server.