Features

Designer features:

Productivity

• Powerful, template based code generation framework
• Written with performance in mind
• Legacy system friendly
• Relational model friendly
• Linq-based project search New!
• Model views New!
• Grouping of project elements New!
• Allows both Model first and Database first development, or a mixture of both New!

Mapping related

• Building blocks for your code: Entities, Value Types, Typed Lists, Typed Views and Stored Procedure calls.
• Full entity type inheritance
• Fields mapped on related fields
• Value Type (DDD) support New!
• All database data types are supported
• Ability to specify abbreviations to full word sets
• Flexible, plug-in driven singularization and pluralization of names
• Database driver architecture (provider model)
• Full support for all relation types
• Full support for complex database constructions
• Support for modified relational schemas
• Support for multiple database types in one project New!
• Support for multiple databases in one project
• Support for multiple catalogs in a single project
• Support for multiple schemas in a single project
• Powerful text-DSL based Quick Model functionality New!

General

• Many databases supported
• SQL Server (MSDE, SqlServer 2000/2005/2008/2008R2/Express, SqlCE Desktop)
• Oracle (Oracle 9i /10g / 11g)
• PostgreSql 7.4+/8.x+,
• Firebird 1.x / 2.x
• IBM DB2 UDB (7.x/8.x/9.x)
• MySql (4.x, 5.x)
• Sybase Adaptive Server Enterprise (ASE)
• Sybase SQL iAnywhere (ASA)
• MS Access 2000/XP/2003/2007/2010
• Generated code supports multiple .NET versions: .NET 2.0/3.0/3.5/4.0 New!
• Generated Visual Studio.NET project files are compatible with Visual Studio.NET 2005/2008/2010
• Multiple target frameworks supported
  • Entity Framework 1.0 / 4.0 New!
  • NHibernate (hbm mappings & Fluent NHibernate mappings) New!
  • Linq to SQL New!
  • LLBLGen Pro runtime framework
• Plug-in system available in the LLBLGen Pro designer
• Full SDK for customers
• Support for C# and VB.NET
• Per target framework extensible settings framework New!
• Designer works disconnected
• Detailed documentation
• Flexible attribute declaration for code generation, no more buddy classes needed New!
• Relational Model Data management New!
• Update / Create DDL SQL script generation New!
• Integrated template editor New!
• Fine-grained project validation New!
• XML based project file New!

LLBLGen Pro runtime features:

Entity management & usage

• 'Transparent persistence' with SelfServicing template set and 'Persistence as a service' with Adapter template set.
• Entities are based on custom classes, not on datasets/datatables
• Typed Lists support
• True database independent code with Type Converters
• Constraint transparency
• Full XML serialization support
• Full XML Webservice / WCF support
• Full binary serialization support
• Typed Views support
• Graph-aware save logic
• Persistence of 'dirty' (changed) data only
• All objects are disconnected from the database
• Server-side paging support for entity collections and typed lists/views
• In-memory filtering and sorting of entity collections through entity views
• Powerful projection framework
• Native Enum support New!
• Map Typed View on stored procedure resultset New!
• DbProviderFactory based New!
• Support for Entity splitting New!
• Hierarchical in-memory projections
• Fetch a resultset as a datareader
• Entity instance uniquing through Context objects
• Dependency injection mechanism
• Authorization support
• Auditing support
• Validation support
• Exclude fields from entity fetches
• Unit of Work and multi-versioning of entity fields
• Advanced lazy loading/load on demand
• Advanced Prefetch functionalty of related entities
• Ability to execute delete/update statements directly on the database
• Easily obtain error codes and other database specific information
• Fine-grained tracing framework
• Support for ADO.NET transactions, COM+ transactions and System.Transactions

Code related

• Full Linq support with our own Linq to LLBLGen Pro provider
• Patterns based generated code
• Code added to the generated classes is preserved
• Full implementation of IBindingList, ITypedList, INotifyPropertyChanged and IEditableObject
• Full support for design time databinding
• Dynamic relation support
• Full ASP.NET 2.0 two-way databinding support
• Partial classes support
• Built-in precision/scale checks for numeric values
• Generics and Nullable types support on .NET 2.0 and higher

SQL related

• Fully object oriented, typed query mechanism
• Table joins seen as object relations and formulated by adding relation objects to a collection
• Compile time checked filter construction, with easy to formulate constructs like (CustomerFields.CompanyName=="SolutionsDesign")
• Ansi joins and non-ansi joins supported
• Join hints can be specified for fine grained control over how joins should take place
• Support for weak (optional) and strong relations (1:1, 1:n, m:1)
• Predicate specification through construction of predicate objects. You can add your own predicate types.
• Custom filter support in JOIN clauses
• 100% typed dynamic filter construction using Predicate objects
• All constructions are database-generic, unless a database specific predicate class is used
• Support for sorting, group by, duplicate filtering and resultset limitations (number of rows returned)
• Full support for nested filter constructions
• Support for full text search on SqlServer
• Support for set based comparisons (sub-queries), expression based comparisons, having clauses in group by collections, like comparisons (case sensitive and case insensitive)
• Scalar query support for easy and efficient retrieval of values from the database
• SQL Expression and aggregate function support in all areas of the query mechanism for as much flexibility as possible when formulating complex queries.
• Join an entity multiple times using aliases for advanced queries spanning multiple times the same entity.
• Polymorphic queries in inheritance scenarios
• Entity type filters in inheritance scenarios
• ScalarQueryExpression support for embedding scalar queries in select lists
• Database function call support, which allows you to call any database function inside an expression.
• CASE support for fine-grained select list tweaking.
• Support for Group By, Having and Aggregate functions
• Advanced Sql Expressions
• Scalar query support
• Flexible concurrency control mechanism
• Full dynamic SQL support
• Derived table support
• Support for stored procedures