VB.Net DAL Generator
Need 50% Discount?
Download this bundle which is 50% OFF.
VB.Net DAL Generator is a .web desktop software that generates VB.Net Data Access Layer for SQL Server and MS Access databases. The goal of this software is to make software program growth straightforward. It creates VB.Net lessons (one per desk) that include strategies for CRUD operations. The generated code can be utilized in internet in addition to desktop apps.
All our Code Generators for PHP, C#, VB.Net and Entity Framework (without source).
All our Code Generators for PHP, C#, VB.Net and Entity Framework (with source code).
Video Demo:
Click here to view the video demo.
Features:
- It creates VB.Net lessons (one for every desk).
- Supports SQL Server and MS Access.
- The class incorporates 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 (SQL Server solely).
- Primary secret is routinely detected for every desk.
- Composite major secret is supported.
- Nullable columns have been dealt with.
- Identity 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 internet functions.
- All the next knowledge kinds of SQL Server are supported:
char, nchar, varchar, nvarchar, textual content, ntext, xml, decimal, numeric,
cash, smallmoney, bit, binary, picture, timestamp, varbinary, date,
datetime, datetime2, smalldatetime, datetimeoffset, time, bigint,
int, smallint, tinyint, float, actual, uniqueidentifier, sql_variant
Sample Application:
A pattern internet software has additionally been supplied that’s utilizing the generated code. In this software one kind (for workers) has been created. This app makes use of the generated knowledge entry layer with out modifying a single line within the generated code.
Generated Code:
- VB.Net Class: For every desk one VB.Net class is created that incorporates all columns of the desk as properties.
- Add Method: It is an occasion technique. It provides a brand new report to the related desk. Nullable columns have been dealt with correctly. If you don’t need to insert values within the nullable columns, don’t specify values for the related properties. Identity and timestamp columns can’t be inserted manually due to this fact these columns are skipped whereas inserting a report. Relevant property of the id column is populated after report is inserted.
- Update Method: It is an occasion technique. It updates an present report. Identity and timestamp columns are skipped whereas updating a report.
- Delete Method: It is a shared technique. It deletes an present report. It takes major key columns values as parameters.
- Get Method: It is a shared technique. It will get an present report (an occasion of the category is created and all properties are populated). It takes major key columns values as parameters.
- GetAll Method: It is a shared technique. 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 also be generated.
