Nhibernate and MS Access

Question

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?

score 11 · Accepted Answer · answered Mar 21 '09 at 16:59

11

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.

answered Mar 21 '09 at 16:59

Reed Copsey

554,122
78
1,158
1,373

5

When you say "MS Access" you mean "Jet". – David-W-Fenton Mar 23 '09 at 05:09
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 Mar 23 '09 at 15:28

score 10 · Answer 2 · answered Mar 21 '09 at 17:43

10

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).

answered Mar 21 '09 at 17:43

yfeldblum

65,165
12
129
169

1

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 Mar 21 '09 at 19:00
3

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. – yfeldblum Mar 21 '09 at 20:47
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! – yfeldblum Mar 21 '09 at 20:48
Why do you want to avoid MS Access ? MS Access is free as database format so I can't see any advantage using other format. – user310291 May 01 '10 at 18:24

score 3 · Answer 3 · answered Mar 21 '09 at 16:59

3

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.

answered Mar 21 '09 at 16:59

Vasil

36,468
26
90
114

Nhibernate and MS Access

3 Answers3

Linked