VB.Net DAL Generator – Source Code by NajmulIqbal15.
VB.Net DAL Generator is a .internet desktop utility that generates VB.Net Data Access Layer for SQL Server and MS Access databases. The goal of this utility is to make tool building simple. It creates VB.Net categories (one according to desk) that comprise strategies for CRUD operations. The generated code can be utilized in internet in addition to desktop apps.
If you want C# DAL Generator for SQL Server and MS Access then click on right here.
If you want C# DAL Generator for MySQL then click on right here.
If you want DAL Generator for Entity Framework (C#/VB.Net) then click on right here.
If you want PHP Code Generator for MySQL/MySQLi/PDO then click on right here.
Click right here to obtain the similar app (with out supply) for simply $19.
Click right here to view the video demo.
- It creates VB.Net categories (one for every desk).
- Supports SQL Server and MS Access.
- The magnificence incorporates all columns of the desk as houses.
- Data sorts had been treated properly.
- Creates strategies for CRUD operations.
- Sorting has been treated.
- Pagination has been treated (SQL Server simplest).
- Primary secret’s routinely detected for every desk.
- Composite number one secret’s supported.
- Nullable columns had been treated.
- Identity column has been treated.
- Timestamp column has been treated.
- Completely indented code is generated.
- The generated code can be utilized in each desktop and internet programs.
- All the next knowledge forms of SQL Server are supported:
char, nchar, varchar, nvarchar, textual content, ntext, xml, decimal, numeric,
cash, smallmoney, bit, binary, symbol, timestamp, varbinary, date,
datetime, datetime2, smalldatetime, datetimeoffset, time, bigint,
int, smallint, tinyint, waft, actual, uniqueidentifier, sql_variant
- Source code (written in C#) has additionally been equipped in order that to allow customers to make adjustments consistent with their programming construction.
A pattern internet utility has additionally been only if is the use of the generated code. In this utility one shape (for workers) has been created. This app makes use of the generated knowledge get admission to layer with out enhancing a unmarried line within the generated code.
- VB.Net Class: For every desk one VB.Net magnificence is created that incorporates all columns of the desk as houses.
- Add Method: It is an example way. It provides a brand new document to the related desk. Nullable columns had been treated correctly. If you don’t wish to insert values within the nullable columns, don’t specify values for the related houses. Identity and timestamp columns can’t be inserted manually subsequently those columns are skipped whilst placing a document. Relevant assets of the identification column is populated after document is inserted.
- Update Method: It is an example way. It updates an present document. Identity and timestamp columns are skipped whilst updating a document.
- Delete Method: It is a shared way. It deletes an present document. It takes number one key columns values as parameters.
- Get Method: It is a shared way. It will get an present document (an example of the category is created and all houses are populated). It takes number one key columns values as parameters.
- GetAll Method: It is a shared way. It will get all information of the related desk. You too can specify seek columns. If sorting/pagination is enabled then the related code can be generated.