Partager via

The ADO.NET Entity Framework - Not Just For SQL Server!

  • Article

As you're hopefully aware, Beta 3 of the ADO.NET Entity Framework is already available. If not, see the ADO.NET team blog here.

You may not be aware of the various ADO.NET provider writers who are publicly pledging their support for the Entity Framework. You can read the entire press release, including information about ADO.NET Data Services (formerly Project Astoria) and ASP.NET 3.5 Extensions here. In terms of third party provider involvement, here are the highlights:

Providers Targeting Publicly Available Versions Within Three Months of RTM

· Core Lab - Providing connectivity to Oracle, MySQL, PostgreSQL and SQLite databases

· IBM - Providing connectivity to both IBM DB2 data server and Informix Dynamic Server (IDS) databases

· MySQL AB - Providing connectivity to MySQL databases

· Npgsql - Providing connectivity to PostgreSQL database versions 7.3+ and 8.x

· OpenLink Software - Providing connectivity to Oracle, Informix, Ingres, Sybase, MySQL, PostgreSQL, DB2, Progress and Microsoft SQL Server databases, and any data source accessible via OpenLink ODBC or JDBC bridge drivers

· Phoenix Software International - Providing connectivity to SQLite databases

· Sybase - Providing connectivity to SQL Anywhere databases

· VistaDB Software - Providing connectivity to VistaDB databases

* - The providers in the list above are also working towards publicly available versions of their providers to work with Beta 3 of the Entity Framework.

Providers Targeting Publicly Available Versions in 2008

· DataDirect Technologies - Providing connectivity to multiple data stores including Oracle, Sybase, Microsoft SQL Server and DB2 via DataDirect Connect® for ADO.NET

· Firebird - Providing connectivity to Firebird databases

If you're writing an ADO.NET provider for the Entity Framework and you're not already in touch with me, please drop me a line at David (dot) Sceppa (at) microsoft (dot) com.

David Sceppa

ADO.NET Program Manager

Microsoft Corporation

Comments

  • Anonymous
    December 17, 2007
    Entity Framework non solo per SQL Server

  • Anonymous
    December 18, 2007
    Which is the calendar? When we will have the release version with oracle? could we use the ODP.net?

  • Anonymous
    December 18, 2007
    Linq to Sql for other databases

  • Anonymous
    December 19, 2007
    There's only tier product for oracle ?

  • Anonymous
    December 27, 2007
    Bom dia! Recentemente eu gravei um webcast sobre o Entity Framework e no final da sessão houve um painel

  • Anonymous
    December 27, 2007
    Bom dia! Recentemente eu gravei um webcast sobre o Entity Framework e no final da sessão houve um painel

  • Anonymous
    January 02, 2008
    > When we will have the release version with oracle?  could we use the ODP.net? Thanks for the interest, Pablo.  We are working closely with other provider writers, including Oracle.  I'll pass along your feedback to let their ODP.NET team know that more and more developers are anxious to use the ADO.NET Entity Framework and ODP.NET to work with their Oracle databases.

  • David
  • Anonymous
    January 02, 2008
    > Linq to Sql for other databases LINQ to SQL is a great technology, but it was designed to work with the SQL Server family of databases.  If you're looking to use LINQ to target other databases, then your best bet is to use LINQ to Entities.
  • David

  • Anonymous
    January 02, 2008
    Sure is interesting! Thx 4 the info, Catto

  • Anonymous
    January 02, 2008
    El mes pasado, el ADO.NET Team, tal como nos comentaba elbruno , sacó una nueva release beta del ADO

  • Anonymous
    January 18, 2008
    Hi, I have one question. If our company is using databases hosted on unix operating systems (mostly freebsd/solaris) and we want to start project using microsoft technologies (mostly IIS 8.0 got our view in upcoming new windows server 2008) what advice would you give us? e.g. we will use postgre sql server, but we want to use asp.net and linq as developement framework. can we connect this 2 heterogenous environments? thank you

  • Anonymous
    January 28, 2008
    > we will use postgre sql server, but we want to use asp.net and linq as developement framework. can we connect this 2 heterogenous environments? I'm hopeful that the PostgreSQL provider that's called out in the press release will work in the environment you've described and will follow up with my contact on that team.

  • David

  • Anonymous
    February 14, 2008
    To be honest, the provider I'm most interested in seeing is one which works over WCF.  For any app which needs to run outside the firewall, the whole Oracle/MS-SQL/Postgres/MySql question is moot. What I really need is a two-part solution: An entity provider for the client which runs over web services, and a service which then makes use of the database-specific entity providers to persist objects. Essentially, something which remotes everything through WCF so that client machines don't need any database providers installed.  This is what rich internet application need in order to make use of Entities. Is this on the roadmap anywhere?  I've looked at ADO Data Services (formerly Astoria), and it looks like a fairly limited data provider for AJAX applications.. Yuck, javascript.

  • Anonymous
    April 03, 2008
    It has been over 3 month since Microsoft has release asp.net 3.5.   Have any of the third partys come up with a way to use linq against Sybase?

  • Anonymous
    August 19, 2008
    Chapter Page Url 4 111 http://msdn2.microsoft.com/en-us/library/bb386907.aspx 4 111 http://msdn2.microsoft.com/en-us/library/bb399400.aspx

  • Anonymous
    October 22, 2008
    one year past, where is oracle provider?

  • Anonymous
    June 03, 2009
    1.5 years past... where's the Oracle provider ???

  • Anonymous
    July 19, 2009
    Thanks for the interest, Pablo.  We are working closely with other provider writers, including Oracle.  I'll pass along your feedback to let their ODP.NET team know that more and more developers are anxious to use the ADO.NET Entity Framework and ODP.NET to work with their Oracle databases.

  • Anonymous
    January 12, 2010
    more than 2 years past... where's the Oracle provider ???

  • Anonymous
    April 15, 2010
    1 year past, where is oracle provider?..

  • Anonymous
    January 27, 2011
    another year, where is oracle provider?

  • Anonymous
    December 01, 2011
    few more months, where is oracle provider? I guess no one cares

  • Anonymous
    August 26, 2012
    can we use entity framework with ms access database

  • Anonymous
    August 28, 2012
    @Anonymous  - There isn't an EF provider for MS Access. Here is a thread on using LINQ against MS Access -  stackoverflow.com/.../linq-asp-net-page-against-ms-access