LINQ and MSAccess Northwind?

  • Thread starter Thread starter Siegfried Heintze
  • Start date Start date
S

Siegfried Heintze

Can I use LINQ with MSAccess Northwind? When I use Visual Studio to drag and
drop the northwind Access database, it says the drivers are not supported!
Why not?
thanks,
Siegfried
 
Siegfried Heintze said:
Can I use LINQ with MSAccess Northwind? When I use Visual Studio to drag
and drop the northwind Access database, it says the drivers are not
supported! Why not?
Click to expand...

The designer in Visual Studio only supports Linq-to-Sql, but not other
databases. There is, AFAIK, no Linq-to-OleDb. You can still use Linq on
Northwind.mdb if you first use a TableAdapter to transfer the data into a
DataSet in memory, and then you use Linq on that DataSet.
 
Siegfried said:
Can I use LINQ with MSAccess Northwind? When I use Visual Studio to drag and
drop the northwind Access database, it says the drivers are not supported!
Why not?
Click to expand...

Linq-2-SQL nor ADO.NET Entity Framework support the Access database. The
Entity Framework does support other database providers other than SQL
Server.

However, there is a 3rd party Linq provider that does support Access and
other database providers.

It's called ALinq.

http://www.alinq.org/en/default.aspx
 
Back
Top