.net - A list of Entity Framework providers for various databases -


Which providers there and their experience using them

I All possible native.NET frameworks are available to address the anti-framework providers that are present, as well as their limitations compared to the default LINQ2Entities (MS for MS SS). Tell me if there's even better for the same database and I'm updating this list with this list.

Add additional providers directly to this post or provide an answer and others will add it to the list (including me). Linq 2 entities - Microsoft SQL Server Connector Entity Framework 1

SQL Server Standard / Enterprise / Express

Microsoft SQL Server CE (compact version)

  • Any provider?

MySQL

  • (since version 6.0) - I have no issues except about Read () , take () and sort () in the same expression tree - all to input your experience / knowledge about it Welcome to

    Note : MySQL Connector / Native Visual Studio Integration is not supported in Express editions of Visual Studio, which means that you can do this in the Database Explorer window MySQL will not be able to see the database or add MyS. Qual Data Source via Visual Studio Wizard Dialog Box Some users can find out that it limits the entity framework and their ability to use MySQL within Visual Studio Express.)
  • - Similar problems: MySQL connector like I have read and both try to blame MS for it [these are the problems]

PostGraySQL

  • Oracle

    • - Community effort project

    DB2

    • There are some IBM data server providers here.

    Sybase

    Informix

    • IBM Data Server Provider

    Firebird

    Provider wrapper

    Units to Microsoft's Linux 4 - NAT Framework 4 ( Beta )

    Microsoft SQL Server

    • 4.0 and Visual Studio 2010; So far the only provider for EF 4

    MySQL

    • , mostly functional but pending issues with the prepared database and database (V6. 3.5)

    SQLite

    <

Microsoft SQL Server Analysis Services (SSAS)

DB2 will work, but if you want to use some out-of-the-box NATT features that all of us Mr. goes (membership and role provider), you do not do well with a lot of work DB2 actually stored procedures in your hands, so you're looking at inline SQL with a lot of parameters.

I had some performance problems with the provider from IBM. I was available from another provider company called Dataidaid. It looks more demonstrative, but it will cost you something like an external website, where speed is important, the cost will probably not be an issue.

I'm sure that if you are building on another platform, DB2 is a great system, but it's actually designed to play nice with NAT. Unless you already do not marry DB2, I look elsewhere.


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

jquery - SimpleModal Confirm fails to submit form -

php - Multiple Select with Explode: only returns the word "Array" -