LLBL Gen Pro 5.0 Introduction to Enterprise application development

Solutions Design released the LLBL Gen Pro 5.0 in May 2016, and the release of this new release was unexpected. My guess is to upgrade from 4.2 to 4.5, then upgrade the 5.x version, the major version number changes will bring the cost of the original customer pressure. The price of 299 euros is not cheap for small or medium-sized startups or big companies, and the latest quotations are checked on the official web, as shown in the following table:

number of licenses	price per License Standard	price per license Plus
1 to 2	€299.-	€398.-
3 to 5	€269.-	€368.-
6 to	€259.-	€358.-
11 to	€249.-	€348.-
more than	€239.-	€338.-

The new version of Llbl Gen Pro has a lot of changes in the interface, with the introduction of an interface style like Visual Studio (VS look-like)-flattening, and some daily operating interfaces are also changing.

1 Create new project, select Llbl Gen Pro Runtime Framework

As seen from this, Llbl Gen Pro supports the development of Entity Framework development and NHibernate. Query from Wikipedia, currently. The following 17 popular ORM frameworks are available in the net domain.

Serial number	Project	Official address
1	Base One Foundation Component Library	Www.boic.com
2	Castle ActiveRecord	http://www.castleproject.org/projects/activerecord/
3	Databaseobjects	Http://www.hisystems.com.au/databaseobjects
4	Dataobjects.net	http://dataobjects.net/
5	Dapper	Github.com/stackexchange/dapper-dot-net
6	ECO	Http://www.capableobjects.com
7	Entity Framework	Msdn.microsoft.com/en-us/data/ef.aspx
8	EntitySpaces	Http://www.entityspaces.net
9	IBATIS	http://ibatis.apache.org
10	LINQ to SQL	Msdn.microsoft.com/en-us/data/ef.aspx
11	Neo	http://neo.sourceforge.net/
12	NHibernate	Nhibernate.info
13	Nhydrate	http://www.nhydrate.org/
14	Persistor.net	http://www.persistor.net/(has expired)
15	Quick Objects	http://www.quickobjects.com/(has expired)
16	Subsonic	http://subsonicproject.com/
17	XPO	https://www.devexpress.com/

Address Https://en.wikipedia.org/wiki/List_of_object-relational_mapping_software

It is a pity that most of the ORM frameworks are discontinued or no longer maintained.

2 Selecting a relational database

Choose to generate a relational model from a database in the Catalog explorer (database Browser)

LLBL Gen Pro supports either Model-first or Database-first two development models, or you can consider creating a new model, and then generate a database script from the Generate DB Schema Create Script menu item. To achieve model-driven development.

We select the SQL Server database driver, set the connection information, and click the Next button.

3 Select the database tables, views, stored procedures to be mapped

After this step, the table has not yet been mapped to the entity, and we need to create the entity object in Database Explorer as a table selection, so that the mapping design for the table and the entity is completed when the form is closed.

Here we have completed the setup of database tables and entity mappings. As shown in the Project Explorer, you see the newly added entity bug, which you can edit by right-clicking the entity, such as setting type Converter, additional properties of the field, and so on.

4 Generating Visual Studio project files and source code files

Click the button in the toolbar to generate source code or press F7, which pops up the Codes generation Options form:

LLBL Gen Pro There is a handy feature improvement here, where we can define one or more build options and save it, and the next time you build the project file, just tick the appropriate project generation options.

Click the button edit Selected Task specifics to eject the build form. Point Advanced ... button to select the Project Generation template.

Then click the OK button to return to the build Options form, which now turns into a green tick indicating that the current build task is valid.

Click Perform Tasks ... Complete the build of the project code.

5 Start visual Studio to load the two projects generated by Llbl Gen Pro, creating a Windows Forms Test project.

In order to read the data from table bugs in database BugTracker, refer to the following steps to complete:

1) Open the Data source form, select Create Data source, select the object type, and select the Bugentity entity generated by step 4th

2) Drag and drop a BindingSource control into the form, and set the data source for this control as the data source for the previous step bugentity

3) Drag a DataGridView control into the interface and select the data source control for the previous step of the data source

In the form Startup event, add the following code to read the bugs table data in the database.

Const string connectionString = "data source= (local); initial catalog=bugtracker;integrated Security=sspi; Persist Security Info=false;packet size=4096";
using New Dataaccessadapter (connectionString))
{
     Irelationpredicatebucket bucket=New relationpredicatebucket ();
     New DateTime (2013, 12, 31));
     Isortexpression sortexpression=New sortexpression (bugfields.bgreporteddate| sortoperator.descending);
     IPrefetchPath2 prefetchpath=New PrefetchPath2 (entitytype.bugentity);
     New Entitycollection (new bugentityfactory ());
     Adapter. Fetchentitycollection (collection, bucket, 0, SortExpression, Prefetchpath,null);
    Bugbindingsource.datasource = collection;
    Gridbugs.datasource = Bugbindingsource;
}

The purpose of this code is to read the bug report date after December 31, 2013, in reverse chronological order of the reported date. I translate it into SQL for reference

WHERE bgreporteddate> '2013/12/31

The entire program development process is written in no more than 10 lines of code, and development efficiency is comparable to Microsoft's Entity Framework and is another heavyweight data access solution outside of EF. There are more than 5,500 customers in more than 100 countries in the world, which are using the ORM development framework.

LLBL Gen Pro 5.0 Introduction to Enterprise application development