NHibernate 5.x Core

[WIP] comparison chart.md

NHibernate vs. Entity Framework

Creating a Model	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
Basic modelling (classes, properties, etc.)	✅	✅
Conventions	✅	✅
Custom conventions	✅	Partial
Data annotations	✅	✅
Fluent API	✅	✅
Inheritance: Table per hierarchy (TPH)	✅	✅
Inheritance: Table per type (TPT)	✅
Inheritance: Table per concrete class (TPC)	✅
Shadow state properties		✅
Alternate keys		✅
Many-to-many: With join entity	✅	✅
Many-to-many: Without join entity	✅
Key generation: Database	✅	✅
Key generation: Client		✅
Complex/value types	✅
Spatial data	✅
Graphical visualization of model	✅
Graphical drag/drop editor	✅
Model format: Code	✅	✅
Model format: EDMX (XML)	✅
Reverse engineer model from database: Command line		✅
Reverse engineer model from database: VS wizard	✅
Incremental update model from database	✅
Querying Data	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
LINQ: Simple queries	Stable	Stable
LINQ: Moderate queries	Stable	Stabilizing
LINQ: Complex queries	Stable	In-Progress
LINQ: Queries using navigation properties	Stable	In-Progress
“Pretty” SQL generation	Poor	✅
Mixed client/server evaluation		✅
Loading related data: Eager	✅	✅
Loading related data: Lazy	✅
Loading related data: Explicit	✅
Raw SQL queries: Model types	✅	✅
Raw SQL queries: Un-mapped types	✅
Raw SQL queries: Composing with LINQ		✅
Saving Data	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
SaveChanges	✅	✅
Change tracking: Snapshot	✅	✅
Change tracking: Notification	✅	✅
Accessing tracked state	✅	Partial
Optimistic concurrency	✅	✅
Transactions	✅	✅
Batching of statements		✅
Stored procedure	✅
Detached graph support (N-Tier): Low level APIs	Poor	✅
Detached graph support (N-Tier): End-to-end		Poor
Other Features	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
Migrations	✅	✅
Database creation/deletion APIs	✅	✅
Seed data	✅
Connection resiliency	✅
Lifecycle hooks (events, command interception, ...)	✅
Database Providers	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
SQL Server	✅	✅
MySQL	✅	Paid only
PostgreSQL	✅	✅
Oracle	✅	Paid only
SQLite	✅	✅
SQL Compact	✅	✅
DB2	✅	✅
InMemory (for testing)		✅
Azure Table Storage		Prototype
Redis		Prototype
Application Models	EF 6.x	EF Core 1.x	NHibernate 4.x	NHibernate 5.x Core
WinForms	✅	✅
WPF	✅	✅
Console	✅	✅
ASP.NET	✅	✅
ASP.NET Core		✅
Xamarin		Coming soon
UWP		✅

[WIP] NH-3807 Pull Request.md

[WIP] NH-3807 Support for .NET Core 1.0 #504

This is currently a work in progress. It does compile and I have ran simple programs against it.

A majority of the changes were done to the mainline .NET version so all the mainline tests could be used during development. There are no tests ported to .NET Core yet, and this may be difficult without the dynamic schema support.

By necessity, it includes #241/NH-3431 - Replace System.Data with System.Data.Common and NH-3853 - Switch binary-serialization to an implementation that is supported by CoreClr.

There are a number of compromises that have to take place on .NET Core, chief among them is that there is no GetSchemaTable(). Without this, none of the dynamic schema generation or updates works. The tests, when implemented, will need a static schema checked into the repository for database restoration.

I think that NHibernate has a number of great features above what Entity Framework is providing and this prevents the choice of .NET Core as being the deciding factor against NHibernate.

Please try this branch out and work to help make it a reality.

Conditional Compilation Symbols

(source for table)

The following conditional compilation symbols (vertical) are currently defined for each of the build configurations (horizontal):

Symbol	NET40	NET45	.NET Core
FEATURE_ADONET_SQLCOMMANDSET	✅	✅	🚫
FEATURE_APPDOMAIN	✅	✅	🚫
FEATURE_ASSEMBLYBUILDER_SAVE	✅	✅	🚫
FEATURE_BINDINGLIST	✅	✅	🚫
FEATURE_CODEDOM	✅	✅	🚫
FEATURE_DATA_CLOSE	✅	✅	🚫
FEATURE_DATA_GETCOLUMNSCHEMA	🚫	🚫	✅
FEATURE_DATA_GETSCHEMATABLE	✅	✅	🚫
FEATURE_DBPROVIDERFACTORIES	✅	✅	🚫
FEATURE_INTERNALIZE_IESI	🚫	🚫	✅
FEATURE_LEGACY_REFLECTION_API	✅	🚫	🚫
FEATURE_NETCORE_ICLONEABLE_API	🚫	🚫	✅
FEATURE_NETCORE_REFLECTION_API	🚫	🚫	✅
FEATURE_ODBC_OLEDB	✅	✅	🚫
FEATURE_REFLECTEDTYPE	✅	✅	🚫
FEATURE_REMOTING	✅	✅	🚫
FEATURE_SECURITY_PERMISSIONS	✅	✅	🚫
FEATURE_SERIALIZATION	✅	✅	🚫
FEATURE_STRING_INTERN	✅	✅	🚫
FEATURE_SYSTEM_CONFIGURATION	✅	✅	🚫
FEATURE_SYSTEM_SERVICEMODEL	✅	✅	🚫
FEATURE_SYSTEM_TRANSACTIONS	✅	✅	🚫
FEATURE_WEB_SESSION_CONTEXT	✅	✅	🚫
FEATURE_XML_SCHEMAS	✅	✅	🚫
FEATURE_XML_VALIDATIONEVENTHANDLER	✅	✅	🚫
---
NET_4_0	✅	✅	🚫
NETSTANDARD	🚫	🚫	✅

• FEATURE_ADONET_SQLCOMMANDSET - enables support for accessing the internal SqlCommandSet for batching. Otherwise, no batching is enabled.
• FEATURE_APPDOMAIN - enables support for features that make use of an AppDomain in the host.
• FEATURE_ASSEMBLYBUILDER_SAVE - enabled support for saving the dynamically generated proxy assembly.
• FEATURE_BINDINGLIST - enables support features that make use of System.ComponentModel.BindingList.
• FEATURE_CODEDOM - enables support for CodeDom providers such as CSharpCodeProvider.
• FEATURE_DATA_CLOSE - enables support for DbDataReader.Close(). .NET Core doesn't have this
• FEATURE_DATA_GETCOLUMNSCHEMA - .NET Core has IDbColumnSchemaGenerator.GetDbColumnSchema on the DbDataReader implementations.
• FEATURE_DATA_GETSCHEMATABLE - DbConnection has GetSchema implementation and DbDataReader has GetSchemaTable. .NET Core has IDbColumnSchemaGenerator.GetDbColumnSchema on the DbDataReader implementations.
• FEATURE_DBPROVIDERFACTORIES - Has DbProviderFactories with globally registered DB providers. Otherwise needs driver assembly with specific name.
• FEATURE_INTERNALIZE_IESI - Since NHibernate 4.0, only LinkedHashSet has been used from Iesi.Collections. We can internalize this and not refer to an external assembly.
• FEATURE_LEGACY_REFLECTION_API - provides a shim for .NET 4.0 that emulates the TypeInfo API available in .NET 4.5+ and .NET Core.
• FEATURE_NETCORE_ICLONEABLE_API - provides shims for missing ICloneable interface
• FEATURE_NETCORE_REFLECTION_API - provides shims to implement missing functionality in .NET Core that has no alternatives.
• FEATURE_ODBC_OLEDB - enables support for features that make use of System.Data.Odbc or System.Data.OleDb.
• FEATURE_REFLECTEDTYPE - Get more precise information from what type a MemberInfo was retreived. Used in MapByCode, but not available in .NET Core.
• FEATURE_REMOTING - supports remoting on various types including inheriting from MarshalByRefObject. Both System.Runtime.Remoting and WCF System.ServiceModel.
• FEATURE_SECURITY_PERMISSIONS - enables the use of CAS and Security[Critical|SafeCritical|Transparent].
• FEATURE_SERIALIZATION - enables support for serialization of dynamic proxies and other types.
• FEATURE_STRING_INTERN - enables support for string.Intern()
• FEATURE_SYSTEM_CONFIGURATION - enables features that use System.Configuration and the ConfigurationManager.
• FEATURE_SYSTEM_SERVICEMODEL enables features that use System.ServiceModel such as WCF and OperationContext.
• FEATURE_SYSTEM_TRANSACTIONS - enables features that use System.Transactions.
• FEATURE_WEB_SESSION_CONTEXT - enables WebSessionContext and relies on System.Web.HttpContext.
• FEATURE_XML_SCHEMAS - enables features around XmlSchema including XmlSchemaSet
• FEATURE_XML_VALIDATIONEVENTHANDLER - enables handling ValidationEventHandler events.