Hi Guys,
I'm currently investigating various options for using ORM frameworks with MS Access.
Given that the EF doesn't work with Access the next option on my list is Nhibernate.
As I understand it, NHibernate can work with MS Access - its just a matter of creating the correct classes and mapping files (please feel free to correct my if I'm wrong here - I'm as new to NHibernate as I am to llblgen).
My problem is - coming from an EF 4.0 background, I am very much of the view that you should be able to create all the class files and mapping files required automaitcally by reverse engineering the database. As far as I can tell NHibernate doesn't have a tool to do this natively (which seems crazy to me) but apparently doing this is possible using llblgen.
Unfortunately although llblgen can do this for various databases (SQL Server/Oracle et al), it doesn't seem to be possible to reverse engineer access databases. Or at least if it can, it can't create the class files and mappings, which kind of defeats the purpose.
Can anyone tell me if it is possible to get Access/NHibernate/Llblgen to work well together or am I barking up the wrong tree?
I've been playing with llblgen and it does seem to be able to read the access file and reverse engineer entities from it. It just doesn't seem to be able to generate the basic class files and mappings.
Many thanks to anyone who can advise on any options for getting this to work!
Best Regards
S