Code First Entity Framework Or NHibernate

Question

I'm pretty new to Code First EF 4.1 and NHibernate. I need to develop a ORM that must have following features.

Perform CRUD with composite key
Use Custom SQL Statement for some case.
Can change connection at run time.
Can Log SQL Statement before or after execution.
Need to support Both MS SQL and Oracle.

I'm a bit confuse which one to choose. Please kindly advice.

Community · Accepted Answer · 2017-05-23 09:58:53Z

4

Well, here's a general comparison of features:

.net ORM Comparison

Regarding your needs, both EF and NH support 1, 2, 3 and 5.

Logging is a different story. EF has absolutely nothing out of the box. NH logs everything, and you can choose diffent levels, loggers, etc.

edited May 23, 2017 at 9:58

CommunityBot

11 silver badge

answered Jul 25, 2011 at 15:23

Diego Mijelshon

52.8k16 gold badges119 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Radim Köhler Over a year ago

Just a NOTE, that both are ... the same (It could be read this way, while you did NOT stated it explicitly;). What makes me crazy in EF is, that I cannot map smallint (DB) into int (C#). Let's say, that DB admins have optimized some primary keys (referenced in a fact table with millions of records - reasonable)... and I have to change App tier implementation. Where is Separation of Concern? That is not an issue with NHibernate. But these small differencies I am finding everywhere...

Community · Accepted Answer · 2017-05-23 12:10:45Z

3

I use NHibernate and I think you can achieve all of your request with it.

Try look here for more info:

Deciding between NHibernate vs Entity Framework?

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Jul 25, 2011 at 7:33

danyolgiax

13.2k10 gold badges71 silver badges118 bronze badges

Comments

Sriram · Accepted Answer · 2011-07-25 08:25:34Z

3

I would go for Nhibernate. It supports all these features and is more battle-tested than EF at this point in time.

answered Jul 25, 2011 at 8:25

Sriram

8487 silver badges15 bronze badges

Comments

Dennis Doomen · Accepted Answer · 2013-03-16 18:56:47Z

2

It might be a bit late, but I've just published a more recent comparison of NHibernate 3.x and Entity Framework 5 and 6. http://www.dennisdoomen.net/2013/03/entity-framework-56-vs-nhibernate-3.html

answered Mar 16, 2013 at 18:56

Dennis Doomen

9,0191 gold badge35 silver badges46 bronze badges

Collectives™ on Stack Overflow

Code First Entity Framework Or NHibernate

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related