Situation:As most developers, using LINQ queries saves a lot of time and works absolutely great. For me one of the greatest tools for quick and easy querying data and testing code is LINQPad. However, sometimes you get a project where the (backend)database is MS Access (yes, it still happens, even in 2016 :) ).
Problem:And there starts the problem. There is no MS Access driver for LINQPad, at least no free one.
Solution:But we are lucky, LINQPad provides a way to create custom drivers. So one of my colleagues, Frank den Outer, made a driver for MS Access to enable you to connect to *.mdb and *.accdb and allows you to query on data from LINQPad on MS Access database (even with password protected ones). So the credits of this post goes to him!
See the screenshots below:
Our company, DNM, offers you this driver for free. You can download is here: MSAccessDataContextDriver.lpx. After the download, start LINQPad, and when creating a new connection, you can easily add the downloaded driver.
Hi the driver is an .lpx file and the access database is a .mdb or .accdb file. -Download the .lpx-file, in LinqPad,
-click on Add connection,
-then click on 'view more drivers...'
-then click on 'browse' and select the .lpx-file
-the driver is added on the top list-box and ready to use it!
Excellent post gained so much of information, Keep posting like this.
Aviation Courses in Chennai
Air hostess training in Chennai
Airline Courses in Chennai
airport ground staff training courses in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai
Post a Comment