Apps

C# DAL Generator for MySQL


Need 50% Discount?

Download this bundle which is 50% OFF.


C# DAL Generator for MySQL is a .net desktop application that generates C# Data Access Layer for MySQL database. The purpose of this application is to make software development easy. It creates C# classes (one per table) that contain methods for CRUD operations. The generated code can be used in web as well as desktop apps.

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

Video Demo

Click here to view the video demo.

Features:

  • It creates C# classes (one for each table).
  • Supports MySQL database.
  • The class contains all columns of the table as properties.
  • Data types have been handled nicely.
  • Creates methods for CRUD operations.
  • Sorting has been handled.
  • Pagination has been handled.
  • Primary key is automatically detected for each table.
  • Composite primary key is supported.
  • Nullable columns have been handled.
  • Auto Increment column has been handled.
  • Timestamp column has been handled.
  • Completely indented code is generated.
  • The generated code can be used in both desktop and web applications.
  • All the following data types of MySQL are supported:
    tinyint, smallint, mediumint, int, integer, bigint, decimal,
    float, double, real, serial, bit, date, datetime, timestamp,
    time, year, char, varchar, nvarchar, tinytext, text, mediumtext,
    longtext, binary, varbinary, tinyblob, mediumblob, blob,
    longblob, enum, set

Generated Code:

  • C# Class: For each table one C# class is created that contains all columns of the table as properties.
  • Add Method: It is an instance method. It adds a new record to the relevant table. Nullable columns have been handled properly. Auto increment and timestamp columns are skipped while inserting a record. Relevant property of the auto increment column is populated after record is inserted.
  • Update Method: It is an instance method. It updates an existing record. Auto increment and timestamp columns are skipped while updating a record.
  • Delete Method: It is a static method. It deletes an existing record. It takes primary key columns values as parameters.
  • Get Method: It is a static method. It gets an existing record (an instance of the class is created and all properties are populated). It takes primary key columns values as parameters.
  • GetAll Method: It is a static method. It gets all records of the relevant table. You can also specify search columns. If sorting/pagination is enabled then the relevant code will also be generated.

Sample Application:

A sample web application has also been provided that is using the generated code. In this application one form (for employees) has been created. This app uses the generated data access layer without modifying a single line in the generated code.

Updates History

Update 1 (Version 1.1):
Upgraded the app to .Net 4.6.1.

More Useful Items:

  1. C# Code Generator for SQL Server/MS Access
  2. C# and VB.Net Code Generator for Entity Framework
  3. PHP Code Generator
  4. Email Scheduler and Bulk Email Sender with Bootstrap
  5. ASP.Net MultiTextBoxInput Web Server Control
  6. Multi Textbox Input jQuery Plugin
  7. Android SMS Filter with Material Design

Download C# DAL Generator for MySQL For Free

You can download C# DAL Generator for MySQL for free. Download the c-dal-generator-for-mysql.zip file using the links below.

How can you install?

For detailed information, you can read the README.MD file in the zip file.

Download c-dal-generator-for-mysql.zip

I have given 1 main and 5 alternative download links below for you. You can download it for free using the links.

File Information

  • Category: Apps
  • File Size: ~3 MB
  • File Type: .zip (compressed)
  • File Name: c-dal-generator-for-mysql.zip

Download Links

1. Direct Links
WebSite Source Link
Direct Download Direct Click Here
Direct Download 2 Direct Click Here
Direct Download (Proxy) Direct Click Here
Google Drive Alternative Click Here
Yandex Disk Alternative Click Here
pCloud Alternative Click Here
MediaFire Alternative Click Here
Dropbox Alternative Click Here
Mega Alternative Click Here
One Drive Alternative Click Here
Amazon S3 Alternative Click Here
Tags:
Categories
Site Templates
14800
WordPress
14459
Mobile
7525
UI Templates
7144
HTML5
6716
Mobile Games
5640
eCommerce
3029
Marketing
2381
PHP Scripts
2305
CMS Themes
1334
Template Kits
1322
JavaScript
1287
Plugins
1010
CSS
713
Muse Templates
703
.NET
646
Blogging
338
Apps
300
Static Site Generators
91
Skins
73
Edge Animate Templates
71
Forums
20