This project has moved. For the latest updates, please go here.

JoinTest failing

Jul 24, 2015 at 5:04 PM
Just been playing with this - I've noticed that the JoinTest fails with a syntax error:

[System.Data.OleDb.OleDbException] = {"Syntax error (missing operator) in query expression '[Extent1].[Standard_StandardId] = [Extent2].[StandardId]\r\nLEFT OUTER JOIN [Standards] AS [Extent3] ON [Extent1].[Standard_StandardId] = [Extent3].[StandardId]'."}

Any plans on getting that working? Should this test be passing?

Thanks for the work so far - looks useful!
Coordinator
Jul 24, 2015 at 5:41 PM
Edited Jul 27, 2015 at 11:26 AM
Thanks for the report. I'll check it soon.
Coordinator
Jul 27, 2015 at 11:29 AM
It should be fixed now.

Was an unexpected (new?) behaviour of EF. The fix was
  • open a new paranteses after from for every join
  • close a new parenteses after the join/on clause
    This is needed by jet provider
Jul 27, 2015 at 11:44 AM
Great, thanks for the quick response!