- Can NHibernate be used as ORM tool for MS Access? We are using Nhibernate to access Sql Server, so wondering if it can be reused.
- If it can be used how has the experience been?
views:
1463answers:
3
+3
A:
Here are the details of using NHibernate with MS Access. I personally haven't done this, as MS Access doesn't include main full database options like stored procedures, etc, so I typically avoid it.
Reed Copsey
2009-03-21 16:59:36
When you say "MS Access" you mean "Jet".
David-W-Fenton
2009-03-23 05:09:26
True. I used MS Access to keep it in the same form as the question, but it's really using NHibernate with the JET db engine Access uses.
Reed Copsey
2009-03-23 15:28:03
A:
It can be used with MS Access. The experience is like any other experience using MS Access as a database for your application, you wish you used something else.
Vasil
2009-03-21 16:59:57
+4
A:
I have used NHibernate with Access. Based on my experience,
- I recommend using NHibernate.
- I recommend avoiding Access.
If you need a file-based in-process mini-database, there are a number of options available, including SQL Server CE (Microsoft, proprietary), Firebird (free-open-source), SQLite (free-open-source). NHibernate supports all these database engines (although I have not had a chance to use them).
Justice
2009-03-21 17:43:47
The reason we want to go for MS Access is the because we are mainly writing MS Office Plug in related applications. Since MS Access comes with Office installation we don't have to install some other database in hundreds of machines (on every client laptop!). Anyway why should we not use Access?
Nazgul
2009-03-21 19:00:11
You don't have to "install" SQLite in your client's machines. All you have to do is package the sqlite .dll file with your mail plugin .dll and you're good to go.
Justice
2009-03-21 20:47:30
I assume Firebird and SQLServerCE work the same but I'm not sure. But that's what makes these things "embedded" databases - you can "embed" them right into your software!
Justice
2009-03-21 20:48:53