C# DAL Generator For MySQL

C# DAL Generator for MySQL

Need 50% Discount?

Download this bundle which is 50% OFF.

C# DAL Generator for MySQL is a .internet desktop software that generates C# Data Access Layer for MySQL database. The goal of this software is to make software program growth simple. It creates C# courses (one per desk) that comprise strategies for CRUD operations. The generated code can be utilized in internet in addition to desktop apps.

If you want C# Code Generator for SQL Server/MS Access then click here.
If you want Code Generator for Entity Framework (C#/VB.Net) then click here.
If you want PHP Code Generator for MySQL/MySQLi/PDO then click here.

Video Demo

Click here to view the video demo.

Features:

It creates C# courses (one for every desk).
Supports MySQL database.
The class accommodates all columns of the desk as properties.
Data sorts have been dealt with properly.
Creates strategies for CRUD operations.
Sorting has been dealt with.
Pagination has been dealt with.
Primary secret is routinely detected for every desk.
Composite major secret is 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 internet purposes.
All the next knowledge forms of MySQL are supported:
tinyint, smallint, mediumint, int, integer, bigint, decimal,
float, double, actual, serial, bit, date, datetime, timestamp,
time, yr, char, varchar, nvarchar, tinytext, textual content, mediumtext,
longtext, binary, varbinary, tinyblob, mediumblob, blob,
longblob, enum, set

Generated Code:

C# Class: For every desk one C# 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 static methodology. It deletes an current report. It takes major key columns values as parameters.
Get Method: It is a static methodology. It will get an current 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 static 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 also be generated.

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. You can obtain the pattern software for free from GitHub repo.