LLBLGen Pro is an O/R mapper and code generator for the Microsoft .NET platform, created by Solutions Design bv. Computer programmers and software architects use this software to create a data-access tier and business objects tier in C# or VB.NET for several O/R mapping frameworks, like NHibernate

NHibernate

- External links :*** *NuGet...

, Entity Framework, Linq to SQL, and its own framework. Because LLBLGen Pro supports a lot of different databases to work with, software developers can choose the best framework and database per project.

History

In 2003, the popular open source tool LLBLGen

LLBLGen

LLBLGen is a simple open source code generator for generating Microsoft SQL Server stored procedures and source code in the .NET languages C# or VB.NET, created by . The source-code of LLBLGen is not publicly offered by Solutions Design, however is available in a .In 2003, LLBLGen was replaced by a...

 was succeeded by this commercial Pro version. Solutions Design bv continued to work on improvements and feature additions, like Linq

LINQ

Linq is a word-based card game from Endless Games, introduced at the American International Toy Fair in 2005.Game play requires at least four players, two of whom are dealt cards with the same word, while the others receive blanks. The goal is to gain points by correctly naming the players with...

 support and the ability to work both database-first and model-first. The current version 3.1 was released in February 2011.

Databases supported

• MS Access 2000/XP/2003/2007/2010
• SQL Server 2000/2005/2008/2008R2/Express/SQL Server CE Desktop
• Oracle 9i/10g/11g
• PostgreSql 7.4+/8.x/9.x
• Firebird 1.5.x/2.x
• IBM DB2 7.x/8.x/9.x (not on AS/400)
• MySql 4.x,5.x (using Core Lab's/DevArt MySql .NET provider)
• Sybase Adaptive Server Enterprise (ASE)
• Sybase iAnywhere (ASA)

O/R mapper frameworks supported

LLBLGen Pro supports the following O/R mapper frameworks

• LLBLGen Pro Runtime Framework 3.1
• Entity Framework v1 (released in .NET 3.5 SP1) and v4 (released in .NET 4)
• Linq to Sql
• NHibernate
  NHibernate
  - External links :*** *NuGet...
  
   2.x/3.x (hbm.xml and FluentNHibernate)

The system is extensible so any 3rd party O/R mapper framework can be utilized in the designer, to consume the abstract entity model plus the mappings to relational model data to generate C# / VB.NET classes and mapping files in the format of the targeted O/R mapper framework.

Feature summary

LLBLGen Pro consists of two parts: a visual designer and the O/R mapper framework.

Key features of the visual designer:

• Model first (entity model is leading) and Database first (relational model/schema is leading) mapping / modelling
• Grouping of project elements
• Value Types (Domain-driven design
  Domain-driven design
  Domain-driven design is an approach to developing software for complex needs by deeply connecting the implementation to an evolving model of the core business concepts...
  
  )
• Model Views, to create visual views over (sub)graphs in the entity model
• Text-DSL based quick model editor for quickly define an entity model by typing facts
• Update/Create DDL SQL script generation
• Built-in template editor
• Template based, task oriented code generation system
• Linq
  LINQ
  Linq is a word-based card game from Endless Games, introduced at the American International Toy Fair in 2005.Game play requires at least four players, two of whom are dealt cards with the same word, while the others receive blanks. The goal is to gain points by correctly naming the players with...
  
   based project search
• Map single entity model onto schemas from multiple database types (e.g. Oracle and SQL Server) in a single project
• Support for multiple O/R mapper frameworks.
• Support for entity inheritance/entity splitting
• Import system to build a model quickly by importing parts from external sources.

Key features of the O/R mapper framework:

• True database independent code
• Full entity type inheritance
• Custom developer code is preserved
• Linq
  LINQ
  Linq is a word-based card game from Endless Games, introduced at the American International Toy Fair in 2005.Game play requires at least four players, two of whom are dealt cards with the same word, while the others receive blanks. The goal is to gain points by correctly naming the players with...
  
   support
• Flexible concurrency mechanism
• Derived table support
• Auditing support
• Authorization support
• Dependency injection
  Dependency injection
  Dependency injection is a design pattern in object-oriented computer programming whose purpose is to improve testability of, and simplify deployment of components in very large software systems....
  
   mechanism
• Fast and compact serialization
• Optimal and fast pre-fetch paths (eager loading)
• Hierarchical in-memory projections
• Native Enum support
• Map Typed View on stored procedure resultset
• WCF Rich Internet application
  Rich Internet application
  A Rich Internet Application is a Web application that has many of the characteristics of desktop application software, typically delivered either by way of a site-specific browser, via a browser plug-in, independent sandboxes, extensive use of JavaScript, or virtual machines...
  
  (RIA) Services support