LINQ with MS Access Database

dotsandcoms
dotsandcoms used Ask the Experts™
on
hi folks,

Can LINQ be used against an Access .mdb database? If yes then please provide the way for it.

many thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Retired
Distinguished Expert 2017
Commented:
Hi dotsandcoms;

Linq to SQL does not support the Access database only MS SQL Server or MS SQL Server Express.

Fernando

Author

Commented:
you mean there is no way to connect to ms access database using LINQ...
Fernando SotoRetired
Distinguished Expert 2017

Commented:
Not to the MS Access database engine.Microsoft never created a driver for it to handle the difference between the to flavors of SQL syntax. About the only way is to load local DataTables and then you could use Linq on it the data tables locally.  
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Commented:
hey,
How about using MS entity Framework and then using LINQ to Entities.

Thanks and regards,
venki

Commented:
also have a look at this discussion.

http://stackoverflow.com/questions/295772/query-microsoft-access-mdb-database-using-linq-and-c

I hope that this helps you.

Thanks and regards,
Venki

Author

Commented:
good solution which help us to upgrade our knowlodge

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial