C# DAL Generator for MySQL – Source Code by NajmulIqbal15.
C# DAL Generator for MySQL is a .web desktop software that generates C# Data Access Layer for MySQL database. The goal of this software is to make device building simple. It creates C# categories (one in step with desk) that include strategies for CRUD operations. The generated code can be utilized in internet in addition to desktop apps.
If you wish to have C# Code Generator for SQL Server/MS Access then click on right here.
If you wish to have Code Generator for Entity Framework (C#/VB.Net) then click on right here.
If you wish to have PHP Code Generator for MySQL/MySQLi/PDO then click on right here.
All our Code Generators for PHP, C#, VB.Net and Entity Framework (with out supply).
All our Code Generators for PHP, C#, VB.Net and Entity Framework (with supply code).
Click right here to view the video demo.
- It creates C# categories (one for every desk).
- Supports MySQL database.
- The elegance accommodates all columns of the desk as homes.
- Data varieties had been treated well.
- Creates strategies for CRUD operations.
- Sorting has been treated.
- Pagination has been treated.
- Primary key’s mechanically detected for every desk.
- Composite number one key’s supported.
- Nullable columns had been treated.
- Auto Increment 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 information sorts of MySQL are supported:
tinyint, smallint, mediumint, int, integer, bigint, decimal,
waft, 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
- Source code has additionally been supplied in order that to allow customers to make adjustments consistent with their programming construction.
- C# Class: For every desk one C# elegance is created that accommodates all columns of the desk as homes.
- Add Method: It is an example way. It provides a brand new report to the related desk. Nullable columns had been treated correctly. Auto increment and timestamp columns are skipped whilst putting a report. Relevant assets of the car increment column is populated after report is inserted.
- Update Method: It is an example way. It updates an current report. Auto increment and timestamp columns are skipped whilst updating a report.
- Delete Method: It is a static way. It deletes an current report. It takes number one key columns values as parameters.
- Get Method: It is a static way. It will get an current report (an example of the category is created and all homes are populated). It takes number one key columns values as parameters.
- GetAll Method: It is a static 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 may also be generated.
A pattern internet software has additionally been only if is the usage of the generated code. In this software one shape (for workers) has been created. This app makes use of the generated information get admission to layer with out editing a unmarried line within the generated code.