Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Interbase and Entity Framework


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Jun 28, 2017 7:31 AM Last Post By: Damian Slanovic
Damian Slanovic

Posts: 42
Registered: 3/23/04
Interbase and Entity Framework  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 27, 2017 11:55 AM
Hi everybody.

I want to create a web application with Visual Studio and MVC4/5. I think Interbase has no support for entity framework, wich means that I can't use it for MVC development.

Am I right? Are there plans to make Interbase available for MVC development?

Regards.
Damian.
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Interbase and Entity Framework  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 27, 2017 12:29 PM   in response to: Damian Slanovic in response to: Damian Slanovic
Damian Slanovic wrote:
Hi everybody.

I want to create a web application with Visual Studio and MVC4/5. I think Interbase has no support for entity framework, wich means that I can't use it for MVC development.

Am I right? Are there plans to make Interbase available for MVC development?

Regards.
Damian.

While I haven't used this, IB does ship with a ADO.NET driver. Looking at
entity framework docs it should be able to use that (just not the ODBC driver).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Damian Slanovic

Posts: 42
Registered: 3/23/04
Re: Interbase and Entity Framework  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 27, 2017 1:43 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Jeff Overcash (TeamB) wrote:
Damian Slanovic wrote:
Hi everybody.

I want to create a web application with Visual Studio and MVC4/5. I think Interbase has no support for entity framework, wich means that I can't use it for MVC development.

Am I right? Are there plans to make Interbase available for MVC development?

Regards.
Damian.

While I haven't used this, IB does ship with a ADO.NET driver. Looking at
entity framework docs it should be able to use that (just not the ODBC driver).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

Thank you Jeff. I'll test it, but it seems too old...

Regards
Damian.

Hi Jeff. I installed the ADO.NET driver but I can't do any progress. Can you please tell me where can I found the entity framework docs you mention before?

Regards.
Damian.

Edited by: Damian Slanovic on Jun 28, 2017 9:12 AM

Edited by: Damian Slanovic on Jun 28, 2017 10:00 AM

From https://stackoverflow.com/questions/6588779/interbase-net-entity-framework-provider

As far as I currently know, there is no support (yet, but it is coming for the near future I believe) for connecting Interbase database with EF. However, it should be possible to write your own provider based upon the guidelines from EF which can be found here. I've come across the exact same issue, which I solved by writing a driver for usage with Interbase XE7 and EF 6 (6.1.2).

To get started, you might want to have a look at the FireBird provider (which is open source) and is already working with EF. If you study the provided code, you might have a good trigger to write your own Interbase provider for EF. The link to FireBirds EF .NET Provider can be found here

As a tip: You need to look at the SQL generator and manifests within the Firebird driver and compare this with the the Interbase SQL grammar. The mappings really differ, but it is just about some small details. When compiling the Firebird driver with the conditional compilation symbols GDS32, the Firebird driver will look and load the gds32.dll provided by Interbase.

Edited by: Damian Slanovic on Jun 28, 2017 11:30 AM

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02