Which service providers are present, and how have you used them?
I'm interested in learning about the available native.NET Framework Entity Framework providers' capabilities as well as how they stack up against the standard LINQ2Entities (from MS for MS SQL). Better still if there are more for the same database. If you tell me, I'll add this list to the article.
Please feel free to add more providers right into this article, or you may respond with an addition and I'll do the same.
Microsoft SQL Server Enterprise/Standard/Express
Windows Server SQL Server CE (Compact Edition)
Connector for MySQL (since version 6.0) - There are problems with utilizing
Everyone is invited to share their experience and expertise about this in the same expression tree.
Note: MySQL Connector/NET Visual Studio Integration is not supported in the Express Editions of Visual Studio, meaning you won't be able to view MySQL databases in the Database explorer window or add a MySQL data source via Visual Studio wizard dialog boxes. Some users may find that this limits their ability to use Entity Framework and MySQL within Visual Studio Express).
85 zzz, 90 zzzzzz, and 94 zzz
Server Microsoft SQL
Analysis Services for Microsoft SQL Server (SSAS)
I doubt DB2 is now compatible with EF 4. If it does, kindly correct me and explain the proper procedure. The DB2 providers will not appear in the Data Source dialogs, at least not for me.