LLBLGen Pro is a commercial, full ORM and entity modeling solution. Its first version was released in 2003. It comes with a visual designer and its own ORM framework, the LLBLGen Pro Runtime Framework. The designer supports, besides their own framework, Entity Framework/Entity Framework Core, Linq to Sql and NHibernate, and offers a rich set of features to use both model-first and database-first development (or a mix of both). Besides your entity model, you can also define multiple derived models on top of the entity model which can e.g. be used as DTOs
The runtime framework offers modern features like .NET Core (through .netstandard 2.0) support, multiple query systems like Linq and its own fluent API, disconnected Unit of work, batching, resultset caching, projections, eager loading and much more. It also offers a plain SQL API for the occasions where you need to express your queries in SQL itself. Its performance is among the top of the field, often outperforming micro ORMs.
All licensees also have access to ORM Profiler, a multi-ORM profiler and query analyzer for .NET data-access code.
The code in this repository uses interfaces on the entities. These are added in the designer as additional interfaces, where the code generator merged them into the output.
LLBLGen Pro supports the following databases:
- SQL Server 2000 or higher / Express / CE Desktop / SQL Azure
- Oracle 9i or higher
- PostgreSQL v7.4 or higher
- IBM DB2 7.x or higher
- MySQL 4.x or higher (and compatible MariaDB variants)
- Google Cloud Spanner
- Firebird 1.5.x or higher
- MS Access 2000 or higher
Additionally it supports through its Derived Model feature the following Document DBs:
- Microsoft Cosmos DB
LLBLGen Pro comes with everything you need in one installer. Additionally, you can pull the runtime framework's assemblies as packages from NuGet:
To get started, please see the Quickstart videos.
In text form:
The complete LLBLGen Pro documentation is vast and has several different parts. They're all available on the main documentation site. Every install also comes with this documentation installed locally.
Support is done via the support forums where the support team and development team answer questions and pick up bug reports. Bug fixes are usually released within a day or two as hotfix builds for licensees.
LLBLGen Pro is a commercial system using a subscription model with a perpetual license, which means the license is valid forever: it won't expire if your subscription expires. Generated code and the runtime framework are royalty free and don't require a license to be used. See the website for more details and the EULA.