Cannot connect to a MS Access database

by the3factory 3/26/2008 5:27:00 PM

Question:

Hello,
 
I have a MS Access 2003 database file, called winners.mdb, which contains a table with several columns. I'm mapping this table to a class called Winner like this:




Code Snippet

Answer1:

My understanding is that LINQ to SQL is tightly bound to SqlClient and thus to SQL Server 200x [Express/MSDE]. It doesn't support SQL Server CE either. 
 
It might better have been named "LINQ to SQL Server."
 
Sorry to deliver the bad news,
 
--rj

Answer2:

Actually, LINQ to SQL is rather decoupled internally.  Between scheduling and other external factors, however, we've only been able to show you a SQL Server provider.



Keith J. Farmer [MSFT]

Answer3:

OK, I see. Any plans to support that for the future?



Microsoft MVP VC++  |  www.mariusbancila.ro | www.mariusbancila.ro/blog

Answer4:

See the following link on codeproject where a great stuff is made: transformation of Linq expressions trees to connect to a MsAccess 2003 database.

DvptUml




Lancet

Tags: linq project general