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

Incorrect SQL Generate when using EF 4.3, Firebird .NET Provider 2.7.0.0, Firebird server 2.5.1 [DNET412] #411

Closed
firebird-automations opened this issue Feb 28, 2012 · 6 comments

Comments

@firebird-automations
Copy link

Submitted by: lennox mcintosh (lennox.mcintosh)

Attachments:
system.data.xml
system.data.xml

Problem occurs when using POCO types with entity framework to connect to an exisiting firebird database on a firebird server.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Provide steps to reproduce.

@firebird-automations
Copy link
Author

Commented by: lennox mcintosh (lennox.mcintosh)

1. Create Dummy Console Application using Visual Studio 2010
2. If app.Config doen't exist add a app.config to console project.
3. Inisde app.config add the following the code (attached in system.data.xml file) underneath the configuration element.
4. Add an appropriate connection string to a Firebird server and Firebird database. Close app.config.
5. Add reference to FirebirdSql.Data.FirebirdClient.dll Assembly to project (verison 2.7.0.0).
6. Add reference to Entity Framework 4.3 (using nuget) to project.
7. Create a simple class with properties that reflects a table from your database, where each property represents a column.
8. Create a context object which extends the Entity Framework's DbContext object.
9. Add a property to this context object, give the property a type of DbSet<T> where T is the simple class from step 7.
10. Using Enitiy Framework inside the main method create a new instance of the context object and select the property in step 9 an then the .ToList method.

This should result in an error.

Please let me know if you need anything else.

@firebird-automations
Copy link
Author

Commented by: lennox mcintosh (lennox.mcintosh)

Please use the 1st system.data.xml

@firebird-automations
Copy link
Author

Modified by: lennox mcintosh (lennox.mcintosh)

Attachment: system.data.xml [ 12106 ]

@firebird-automations
Copy link
Author

Modified by: lennox mcintosh (lennox.mcintosh)

Attachment: system.data.xml [ 12107 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

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

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants