Opentopia Directory Encyclopedia Tools

LLBLGen Pro

Encyclopedia : L : LL : LLB : LLBLGen Pro



 

LLBLGen Pro is an O/R mapper and data-access tier generator for .NET. It generates a data-access tier and business façade/support tier (in C# or VB.NET), using an existing database schema set. The generated .NET code is provided as a Visual Studio.NET project that can be added to a solution or compiled separately.

Aside from creating entities based on database tables, LLBLGen Pro supports Typed Lists, which are lists of fields from a set of entities which have 1:1, 1:n or m:1 relations which each other. It also lets you create Typed Views, which reflect existing database views. Stored procedures can be wrapped as static methods so that they can be called conveniently.

A key feature in LLBLGen Pro is dynamically generated SQL. When retrieving or manipulating data in a database, the SQL script, the code understood by the database, is generated at runtime based off the requested information and dirty flags in each entity's fields. This enables a generic save entity function on the Data Access Tier to produce different and optimized SQL code each time it is called, optimizing bandwidth usage and database load.

The code generation process is flexible. The code is generated from a set of built-in templates that can be customized by the developer using a graphical tool. There is also an SDK provided for controlling the generation process.

External links

 


From Wikipedia, the Free Encyclopedia. Original article here. Support Wikipedia by contributing or donating.
All text is available under the terms of the GNU Free Documentation License See Wikipedia Copyrights for details.


Search Titles
0123456789
ABCDEFGHIJ
KLMNOPQRST
UVWXYZ?

E-mail this article to:

Personal Message: