NHibernate vs EF

[Michael Powell]

Hello,

I've run into some strange cycle and then also CRUD order issues causing FK failures with EF that have me wondering the efficacy of continuing with it for my ORM needs. Wondering if NHibernate (and/or Fluent) are any better about these sorts of things? Is there perhaps a run down comparison of features hibernate versus EF that might talk about these kinds of things? Appreciate any insights, thank you...

Best,

Michael W. Powell

[Frédéric Delaporte]

Hi,

NHibernate has a CRUD operations ordering logic meant to get things done as they should. But I guess EF is supposed to do so too. You would have to test your troublesome cases with NHibernate to check what it gives.

I do not know about a comparison between NHibernate and EF about this kind of issues.

Regards,

Frédéric

[Michael W Powell]

Appreciate the response. At least based on this issue, I would guess that EF does not do the appropriate mapping ordering, which is not a little troublesome.

Child Entity Insert Order Incorrect (closed not planned)

https://github.com/dotnet/efcore/issues/11686

Bit more in depth survey of my project re: database (pg), which first strategies, possible NH+FNH feasibility.

https://github.com/nhibernate/fluent-nhibernate/discussions/746

Thanks!