C# DAL Generator for MySQL – Source Code (Database Abstractions)

C# DAL Generator for MySQL is a .internet desktop software that generates C# Knowledge Entry Layer for MySQL database. The aim of this software is to make software program improvement straightforward. It creates C# courses (one per desk) that include strategies for CRUD operations. The generated code can be utilized in net in addition to desktop apps.

In the event you want C# Code Generator for SQL Server/MS Entry then click here.
In case you want Code Generator for Entity Framework (C#/VB.Internet) then click here.
In case you want PHP Code Generator for MySQL/MySQLi/PDO then click here.

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).

Video Demo

Click here to view the video demo.

Options:

  • It creates C# courses (one for every desk).
  • Helps MySQL database.
  • The category incorporates all columns of the desk as properties.
  • Knowledge varieties have been dealt with properly.
  • Creates strategies for CRUD operations.
  • Sorting has been dealt with.
  • Pagination has been dealt with.
  • Main key’s mechanically detected for every desk.
  • Composite main key’s supported.
  • Nullable columns have been dealt with.
  • Auto Increment column has been dealt with.
  • Timestamp column has been dealt with.
  • Utterly indented code is generated.
  • The generated code can be utilized in each desktop and net purposes.
  • All the next knowledge varieties 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
  • Supply code has additionally been offered in order that to allow customers to make modifications in accordance with their programming construction.

Generated Code:

  • C# Class: For every desk one C# class is created that accommodates all columns of the desk as properties.
  • Add Technique: It’s an occasion technique. It provides a brand new document to the related desk. Nullable columns have been dealt with correctly. Auto increment and timestamp columns are skipped whereas inserting a report. Related property of the auto increment column is populated after document is inserted.
  • Replace Technique: It’s an occasion technique. It updates an present document. Auto increment and timestamp columns are skipped whereas updating a document.
  • Delete Technique: It’s a static technique. It deletes an present document. It takes main key columns values as parameters.
  • Get Technique: It’s a static technique. It will get an present report (an occasion of the category is created and all properties are populated). It takes main key columns values as parameters.
  • GetAll Technique: It’s a static technique. It will get all data of the related desk. It’s also possible to specify search columns. If sorting/pagination is enabled then the related code will even be generated.

Pattern Software:

A pattern net software has additionally been offered that’s utilizing the generated code. On this software one type (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.