When comparing BlackHole.Core.ORM vs Entity Framework, the Slant community recommends Entity Framework for most people. In the question“What are the best ORMs for C#?” Entity Framework is ranked 3rd while BlackHole.Core.ORM is ranked 21st. The most important reason people chose Entity Framework is:
List all versions of a schema, apply one or go back to a previous version.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Direct mapping to DTOs
Pro Can perform Joins using C#
Pro Can parse an existing database
It generates entities using its Cli
Pro Supports 5 databases out of the box
Pro High performance
Pro Easy to set-up
Pro Easy to use
Pro Migrations API
List all versions of a schema, apply one or go back to a previous version.
Pro Database support
Supports most popular databases.
Pro Documentation
Better than the chaotic and confusing NHibernate documentation.
Pro Typesafe queries
Linq2Sql allows writing queries using the actual ORM types. This prevents issues when modifying the schema/entities.
Pro Avoids creation of inline SQL queries
No longer do you have to create/close SQL connections every time you want to interact with the database. You also don't have to maintain a database reader to handle the results retrieved from the database; all of this functionality is easily handled through LINQ queries and Entity Framework.
Pro Database agnostic
You can quite easily migrate from using one DB technology to another.
Pro Non intrusive object model
Object model is non-intrusive and consistent.
Cons
Con It's made by a single developer
Con Complicated
For simple data storage scenarios, EF may be unnecessarily complicated to learn.
Con Performance
Micro-ORMs have better performance.