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

Published 17 December 07 05:40 PM | dpblogs 

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Blog di Luca Beretta said on December 18, 2007 4:36 AM:

Entity Framework non solo per SQL Server

# Pablo Castilla said on December 18, 2007 4:14 PM:

Which is the calendar? When we will have the release version with oracle?

could we use the ODP.net?

# Brendan Kowitz's .NET Blog said on December 18, 2007 4:26 PM:

Linq to Sql for other databases

# neo.51 said on December 20, 2007 4:11 AM:

There's only tier product for oracle ?

# LUTI @ Microsoft said on December 27, 2007 1:52 PM:

Bom dia! Recentemente eu gravei um webcast sobre o Entity Framework e no final da sessão houve um painel

# Noticias externas said on December 27, 2007 2:57 PM:

Bom dia! Recentemente eu gravei um webcast sobre o Entity Framework e no final da sessão houve um painel

# dpblogs said on January 2, 2008 3:32 PM:

> 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

# dpblogs said on January 2, 2008 3:34 PM:

> 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

# ccatto said on January 2, 2008 9:08 PM:

Sure is interesting! Thx 4 the info, Catto

# QuintaStation said on January 3, 2008 7:14 AM:

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

# Steve Raynold said on January 18, 2008 3:31 PM:

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

# dpblogs said on January 28, 2008 8:49 PM:

> 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

# Daryl said on February 14, 2008 4:28 PM:

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.

# Pete554IsFun@SnapsInTime.com said on April 3, 2008 10:26 AM:

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?

# Programming Linq Book Log said on August 19, 2008 1:26 PM:

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

# unruledboy said on October 23, 2008 3:47 AM:

one year past, where is oracle provider?

# Hasteq said on June 3, 2009 10:55 AM:

1.5 years past... where's the Oracle provider ???

Leave a Comment

(required) 
(optional)
(required) 
Page view tracker