Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Entity Framework produces invalid Firebird query when using INCLUDE and SKIP together [DNET404] #407

Closed
firebird-automations opened this issue Jan 17, 2012 · 7 comments
Closed

Entity Framework produces invalid Firebird query when using INCLUDE and SKIP together [DNET404] #407

firebird-automations opened this issue Jan 17, 2012 · 7 comments
Assignees
@cincuranet
Labels
component: entity framework priority: major resolution: duplicate type: bug

Comments

@firebird-automations
Copy link

Submitted by: NoPyGod (nopygod)

Duplicates DNET432

Attachments:
test.zip

Votes: 1

When using both Join and Skip, a query with unaccepted syntax is generated.

I have posted about this issue on Stackoverflow

http://stackoverflow.com/questions/8889714/entity-framework-produces-invalid-firebird-query-when-using-include-and-skip-tog
@firebird-automations
Copy link
Author

Commented by: NoPyGod (nopygod)

This is a test project which shows the problem

@firebird-automations
Copy link
Author

Modified by: NoPyGod (nopygod)

Attachment: test.zip [ 12088 ]

@firebird-automations
Copy link
Author

Commented by: NoPyGod (nopygod)

I notice the other issue I created DNET405 has been deleted. It's a shame because it had more information on it, and it was probably in a more correct category. How come nobody has responded to this yet? This seems like a pretty serious issue. Doing a join and a skip together isn't exactly an edge case.

@firebird-automations
Copy link
Author

Commented by: haos (haos11)

I came across the same bug. If you join two tables in Linq query (using join operator or using navagation property) and apply Skip() method, it produces wrong sql query. Please, fix this. It is impossible to write an application that does not use Entity Framework queries which join two or more tables.

@firebird-automations
Copy link
Author

Commented by: Dmitry Laptev (mrain)

Has faced the same issue.
Could please someone of the development team give a response on this?

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue duplicates DNET432 [ DNET432 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Duplicate [ 3 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@cincuranet cincuranet

Labels
component: entity framework priority: major resolution: duplicate type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@cincuranet @firebird-automations