Codecanyon new Database Abstractions items

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

2017-09-07 22:25:46

Need 50% Discount?

Download this bundle which is 50% OFF.

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.

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.

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# 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
Source code has also been provided so that to enable users to make changes according to their programming structure.

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.

VB.Net DAL Generator - Source Code (Database Abstractions)

2017-06-21 00:38:38

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

VB.Net DAL Generator is a .net desktop application that generates VB.Net Data Access Layer for SQL Server and MS Access databases. The purpose of this application is to make software development easy. It creates VB.Net classes (one per table) that contain methods for CRUD operations. The generated code can be used in web as well as 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 $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 VB.Net classes (one for each table).
Supports SQL Server and MS Access.
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 (SQL Server only).
Primary key is automatically detected for each table.
Composite primary key is supported.
Nullable columns have been handled.
Identity 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 SQL Server are supported:
char, nchar, varchar, nvarchar, text, ntext, xml, decimal, numeric,
money, smallmoney, bit, binary, image, timestamp, varbinary, date,
datetime, datetime2, smalldatetime, datetimeoffset, time, bigint,
int, smallint, tinyint, float, real, uniqueidentifier, sql_variant
Source code (written in C#) has also been provided so that to enable users to make changes according to their programming structure.

Sample Application:

Generated Code:

VB.Net Class: For each table one VB.Net 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. If you don’t want to insert values in the nullable columns, don’t specify values for the relevant properties. Identity and timestamp columns cannot be inserted manually therefore these columns are skipped while inserting a record. Relevant property of the identity column is populated after record is inserted.
Update Method: It is an instance method. It updates an existing record. Identity and timestamp columns are skipped while updating a record.
Delete Method: It is a shared method. It deletes an existing record. It takes primary key columns values as parameters.
Get Method: It is a shared 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 shared 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.

SQL Server Procedures Generator - Source Code (Database Abstractions)

2017-05-03 22:28:30

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

SQL Server Procedures Generator is a .Net desktop application that generates stored procedures for CRUD operations for the whole database by single click.

Save $20

Click here to download the same app (without source) for just $58.

Video Demo

Click here to view the video demo.

Features:

It generates procedures for CRUD operations (Add, Update, Delete, Get and GetAll).
You can save the generated script to a single file or multiple files (one file per table).
Primary key is automatically detected for each table.
Composite primary key is supported.
Identity (auto increment) column is automatically detected and is not included in the Insert and Update clauses.
Timestamp column has been handled (cannot be inserted/updated manually).
Completely indented code is generated.
Supports all the data types of SQL Server 2008 R2.
Source code has also been provided so that to enable users to make changes according to their requirements.

More Useful Items:

Entity Framework DAL Generator - Source Code (Database Abstractions)

2017-02-16 17:57:17

Need 50% Discount?

Download this bundle which is 50% OFF.

Entity Framework DAL Generator is a .Net desktop application that generates entity framework data access layer (C# and VB.Net) for SQL Server database. This software makes the .Net development easy.

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 $40

Click here to download the same app (without source) for just $78.

Video Demo:

Click here to view the video demo.

Features:

It generates separate classes for each table.
Data types have been handled nicely.
Creates methods for SCRUD (Search, Create, Read/Retrieve, Update and Delete/Destroy) operations.
Generates C# as well as VB.Net code.
Supports entity framework 4 and 6.
Methods can be added as extensions to entity classes.
Pagination has been handled.
Sorting has been handled.
Search has been handled.
Primary key is automatically detected for each table.
Composite primary key is supported.
Completely indented code is generated.
Supports all data types of SQL Server that are supported by Entity Framework 4.0.
The generated code can be used in both desktop and web applications (ASP.Net Web Forms as well as MVC Application).
Source code has also been provided.
The source code has been well documented.
You need one copy per user and can use it for unlimited end products.

Sample Application:

A sample C# 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.

Generated Code:

C# Class: For each table one C#/VB.Net class is created that contains methods for SCRUD operations.
Add Method: It adds a new record to the relevant table.
Update Method: It updates an existing record. It takes primary key columns values as parameters.
Delete Method: It deletes an existing record. It takes primary key columns values as parameters.
Get Method: It gets an existing record. It takes primary key columns values as parameters.
GetAll 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.

SQL Helper (Database Abstractions)

2016-07-12 12:41:02

What is SQL Helper?

I’m sharing this with the world because we need another way to access data – don’t you think? Truthfully – I wanted to see if I could flex the C# stuff and run up data access with a single dll and signle line of functions.

Features

Fetch data with signle line of functions
Fetch data with custome column’s name
Fetch data with sorting
Fetch data with diffrent type of joins
Fetch data with paging
SQL error handling
Full dll source code – (You can customize as your own way)
Development time saving…

Demo Code

Select All Rows With All function
```
dTable.All("TableName");
```

Fetch data with Select function

dTable.Select("TableName");
dTable.Select("TableName", "Columns");
dTable.Select("TableName", "Columns", "Where");
dTable.Select("TableName", "Columns", "Sort", "SortType");
dTable.Select("TableName", "Columns", "Where", "Sort", "SortType");

Select function is very usefull and it has five overload methods.
All parameters description is above this function.

Fetch data with Where function

dTable.Where("TableName", "Where");
dTable.Where("TableName", "Where", "Columns");
dTable.Where("TableName", "Where", "Columns", "Sort", "SortType");

Fetch data with OrderBy function

dTable.OrderBy("TableName", "Sort", "SortType");
dTable.OrderBy("TableName", "Sort", "SortType", "Columns");
dTable.OrderBy("TableName", "Sort", "SortType", "Columns", "Where");

Fetch data with Paged function

dTable.Paged("TableName", "PageIndex", "PageSize");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where", "Sort", "SortType");

You can fetch data with paging and you paging result will return with MyResult class.
PageIndex you require to pass your current page index. which you require to show in list.
PageSize pass your current page size.

Support

Once again, As I said at the beginning, I’d be glad to help you if you have any questions relating to this code. I’ll do my best to assist. If you have a more general question relating to the code on CodeCanyon, you might contact me at here. Thanks so much!.

For new features:

Though we will never discourage users from developing solutions that solve their needs, the goals of the SQL Helper are very focused. If you are looking to get new features merged back into the SQL Helper DLL, we highly encourage you to contact me at ajmerainfo@gmail.com or write comment on my CodeCanyon this product page.

Thanks.

hit counter

Auto Backup DB for SQL Server with Source Code (Database Abstractions)

2015-04-10 14:23:33

Auto Backup DB software is used to backup your SQL Server database automatically. You can set unlimited database with the backup time and location of the backup folder can be determined. This software can be easily installed and set up. Software will run automatically when the computer is turned on. With this software, you do not need to take the time to backup manually every time. Software is working 24 hours / 7 days as long as the server is powered on.

Features :

Automatic Start when Windows Logon
Set Backup Time for every Database
Set Backup Location for every Database
Can Backup Unlimited Database
Unlimited Instance on 1 Server
Compatible for All SQL Server Version
Documentation for Use Apps

What You Get :

Full Source Code (You Can Customize it for Your Apps)
Images File for Icon in Form

Source Code Compatibilty :

With Visual Studio 2008 or later.

Support :

If you have problems & questions, contact me via contact form on my author profile.

Employee directory for Windows Phone (Database Abstractions)

2015-03-12 04:32:17

This is a Employee directory For Windows Phone 8.0,8.1. Windows phone Database application. Windows Phone CRUD Application.

This is A new Employee directory Apps. Employee directory is easy to access information of all employees.
Using this apps user can make call, SMS, Email and so all. This is a Employee Database. User can Store information of all employees, edit and delete.

Full C# code , SQLite Database / Compact Database, and new

Feature

You can add new Employee Info.
Update all information
Make Phone call , SMS , Email via this apps
Search Employee by contact, Name ..

Live Demo

What You Get:

Full Windows Phone Apps Source Code.
Compact Data base 3.5
Full XAML and CS Code of Server Side.
User manual Document with Screen Shot.

Works with:

Windows Phone 8.1
Windows Phone 8
Windows Phone 7.5

Requirements:

Visual studio 2012 express for Windows Phone
Or Visual studio 2013
For Compact Data base 3.5 modification VS 2010

Support

citkar@live.com