LLBLGen Pro

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.

Info

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.

Supported Databases

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:

  • RavenDB
  • MongoDB
  • Microsoft Cosmos DB

Libraries

LLBLGen Pro comes with everything you need in one installer. Additionally, you can pull the runtime framework's assemblies as packages from NuGet:

Setup

To get started, please see the Quickstart videos.

In text form:

Documentation and Tutorials

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.

Bug Reporting

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.

Licensing

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.