VB.Net DAL Generator for MySQL
Need 50% Discount?
Download this bundle which is 50% OFF.
If you want C# DAL Generator for SQL Server and MS Access then click here.
If you want C# DAL Generator for MySQL then click here.
If you want DAL Generator for Entity Framework (C#/VB.Net) then click here.
If you want PHP Code Generator for MySQL/MySQLi/PDO then click here.
VB.Net DAL Generator for MySQL is a .internet desktop software that generates VB.Net Data Access Layer for MySQL database. The goal of this software is to make software program growth straightforward. It creates VB.Net courses (one per desk) that comprise strategies for CRUD operations. The generated code can be utilized in net in addition to desktop apps.
Video Demo:
Click here to view the video demo.
Features:
- It creates VB.Net courses (one for every desk).
- It helps MySQL database.
- The class accommodates all columns of the desk as properties.
- Data varieties have been dealt with properly.
- Creates strategies for CRUD operations.
- Sorting has been dealt with.
- Pagination has been dealt with.
- Primary secret’s routinely detected for every desk.
- Composite main secret’s supported.
- Nullable columns have been dealt with.
- Auto Increment column has been dealt with.
- Timestamp column has been dealt with.
- Completely indented code is generated.
- The generated code can be utilized in each desktop and net functions.
- All the next knowledge sorts of MySQL are supported:
tinyint, smallint, mediumint, int, integer, bigint, decimal,
float, double, actual, serial, bit, date, datetime, timestamp,
time, 12 months, char, varchar, nvarchar, tinytext, textual content, mediumtext,
longtext, binary, varbinary, tinyblob, mediumblob, blob,
longblob, enum, set
Sample Application:
A pattern net software has additionally been supplied that’s utilizing the generated code. In this software one type (for staff) has been created. This app makes use of the generated knowledge entry layer with out modifying a single line within the generated code.
Updates History
Update 1 (Version 1.1):
Upgraded the app to .Net 4.6.1.
Generated Code:
- VB.Net Class: For every desk one VB.Net class is created that accommodates all columns of the desk as properties.
- Add Method: It is an occasion methodology. It provides a brand new report to the related desk. Nullable columns have been dealt with correctly. Auto increment and timestamp columns are skipped whereas inserting a report. Relevant property of the auto increment column is populated after report is inserted.
- Update Method: It is an occasion methodology. It updates an current report. Auto increment and timestamp columns are skipped whereas updating a report.
- Delete Method: It is a shared methodology. It deletes an current report. It takes main key columns values as parameters.
- Get Method: It is a shared methodology. It will get an current report (an occasion of the category is created and all properties are populated). It takes main key columns values as parameters.
- GetAll Method: It is a shared methodology. It will get all data of the related desk. You can even specify search columns. If sorting/pagination is enabled then the related code may even be generated.
