[ad_1]
To get this product on 50 % low cost contact me on this link
C# DAL Generator is a .internet desktop utility that generates C# Data Access Layer for SQL Server and MS Access databases. The objective of this utility is to make software program growth straightforward. It creates C# lessons (one per desk) that include strategies for CRUD operations. The generated code can be utilized in net in addition to desktop apps.
If you want C# DAL Generator for MySQL then click here.
If you want DAL Generator for Entity Framework (C#/VB.Net) then click here.
If you want PHP Code Generator for MySQL/MySQLi/PDO then click here.
Save $20
Click here to download the same app (without source) for just $39.
Video Demo
Click here to view the video demo.
Features:
- It creates C# lessons (one for every desk).
- Supports SQL Server and MS Access.
- The class comprises 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 (SQL Server solely).
- Primary secret’s robotically detected for every desk.
- Composite major secret’s supported.
- Nullable columns have been dealt with.
- Identity 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 net purposes.
- All the next knowledge forms of SQL Server are supported:
char, nchar, varchar, nvarchar, textual content, ntext, xml, decimal, numeric,
cash, smallmoney, bit, binary, picture, timestamp, varbinary, date,
datetime, datetime2, smalldatetime, datetimeoffset, time, immenseint,
int, smallint, tinyint, float, actual, uniqueidentifier, sql_variant - Source code has additionally been supplied in order that to allow customers to make adjustments in line with their programming construction.
Sample Application:
A pattern net utility has additionally been supplied that’s utilizing the generated code. In this utility 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.
Generated Code:
- C# Class: For every desk one C# class is created that comprises 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. If you don’t need to insert values within the nullable columns, don’t specify values for the related properties. Identity and timestamp columns can’t be inserted manually subsequently these columns are skipped whereas inserting a file. Relevant property of the id column is populated after file is inserted.
- Update Method: It is an occasion technique. It updates an present file. Identity 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 data of the related desk. You also can specify search columns. If sorting/pagination is enabled then the related code can even be generated.
[ad_2]
To get this product on 50 % low cost contact me on this link
