Which O/RM tool supports Microsofts Access?

Question

For one of my clients I'm currently building an application that communicates with a legacy Microsoft Access database. Migrating to SQL server is unfortunately not (yet) an option. I currently write the queries using OleDbConnection, OleDbCommand and –good old- text based queries. As you can imagine I'm a bit spoiled by using modern O/RM tools and I feel like I went back in time.

Which O/RM tool supports Microsoft Access so I can get rid of this uglyness?

Answer 1

Nhibernate and MS Access

LLBLGEN

How can I use MS Access as a provider for ADO.NET entity framework ?

Answer 2

ALinq, http://www.alinq.org

Answer 3

I've also used EntitySpaces for my project work with a Legacy MSAccess -> SQLServer changeover project. So if you go down that path it's pretty straight forward.

Answer 4

Checkout XmlDataMapper a simple free ORM (LGPL Licence) which supports almost all databases including Access The sample project provided should be good enough to get started.

To integrate XmlDataMapper all you need to do is 4 little steps

1. Create a Business Entity / DTO for the tables in the Database
2. Create an XML File with the mapping information between the table and the DTO.
3. Specify the DTO and xml file in the configuration.
4. Just call the DTOConverter.Convert(dataReader) and other such methods to convert your database record to DTO / Business Entity