
C# DAL Generator for MySQL – Source Code
Need 50% Discount?
Download this bundle which is 50% OFF.
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.
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 software program growth simple. It creates C# courses (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).
Save 33%
Click here to download the same app (without source) and save 33%.
Video Demo
Click here to view the video demo.
Features:
- It creates C# courses (one for every desk).
- Supports MySQL database.
- 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.
- 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 functions.
- All the next information sorts 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 - Source code has additionally been supplied in order that to allow customers to make modifications in keeping with their programming construction.
Generated Code:
- C# Class: For every desk one C# class is created that incorporates all columns of the desk as properties.
- Add Method: It is an occasion technique. It provides a brand new file to the related desk. Nullable columns have been dealt with correctly. Auto increment and timestamp columns are skipped whereas inserting a file. Relevant property of the auto increment column is populated after file is inserted.
- Update Method: It is an occasion technique. It updates an present file. Auto increment and timestamp columns are skipped whereas updating a file.
- Delete Method: It is a static technique. It deletes an present file. It takes major key columns values as parameters.
- Get Method: It is a static technique. It will get an present file (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 technique. It will get all information of the related desk. You may also specify search columns. If sorting/pagination is enabled then the related code may even be generated.
Sample Application:
A pattern internet 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 information entry layer with out modifying a single line within the generated code. You can obtain the pattern software for free from GitHub repo.
Updates History
Update 1 (Version 1.1):
Upgraded the app to .Net 4.6.1.