search

bubibubi / JetEntityFrameworkProvider

Microsoft Access (Jet) Entity Framework provider
89 stars 26 forks source link

jetentityframeworkprovider fails executing custom EF Include (IncludeOptimized) #34

Closed Keops31 closed 6 years ago

Keops31 commented 6 years ago

Hello,

I could not make work the method IncludeOptimized from Nuget Z.EntityFramework.Plus.QueryIncludeOptimiz (v1.7.11) on an Access DB using the EF provider jetentityframeworkprovider (v6.1.5rc2).

This method IncludeOptimized is supposed to provide performance enhancement on nested EF "Include" statements (http://entityframework-plus.net/query-include-optimized).

The error message: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE' Error number: 2147217900

Thanks for your support

Keops31 commented 6 years ago

It seems that MS ACCESS is not supported provided by IncludeOptimized NuGet. https://github.com/zzzprojects/EntityFramework-Extensions/issues/107

Hence, not an issue from jetentityframeworkprovider