Tutorial for beginner

Watch tutorial
Video of Data Access Agility to start

Watching this short video will save you days of work

In this tutorial, you will learn how to generate data access code for a small software application. At the end of this tutorial, you will be able to get database schema scripts, persistence entities, and data access objects for your application

Define Database Schema

Define your database schema using easy to use GUI without regard to database technology

Define Data Access Layer

Specify the persistence operations for your application without writing any SQL queries

Generate Code

Download the persistance entities, data access objects, and database schema scripts

Brand new tool to blow your mind

We’ve developed a tool
that will save you time and effort

Create the data access layer of your application using easy to use GUI. Choose among different databases and programming languages, including MySql Server, Oracle, Microsoft SQL Server, Java, and C#; and get the data access layer generated for you in seconds. That is not all, Data Access Agility allows you to generate different types of data access operations, such as update single field, read single field, insert bulk records, and read bulk records.

Get Started now

01 

Object-Relational Mapping (ORM)

Define the mapping between persistence entities and anderlying database using easy to use GUI. You do not have to create any configuration file to define the mapping; the generated data access objects will handle the mapping for you.

02

Custom Persistence Operations

Get data access objects (DAO) that exposes customized persistence operations without writing any SQL query! You can, for example, define a data access operation that updates single field, reads single field, inserts multiple records, or reads multiple records. Remember, everything is done easily using a graphical user interface

03

Business Intelligence

Generate data access code for reports and dashboards without writing any custom code. Business Intelligence panel allows you to generate code for very complex queries that could retreive aggregated data from multiple tables.

04

Persistence Entities

Generate the code of persistence entities without writing any line of code. You can still provide identifiers to persistence entities different from names of database fields. Persistence entities are represented as strongly-typed classes in Java and C#.

05

Documentation

Database Documentation has always been challenging! Data Access Agility allows you to document the database while defining its schema. Documentation will be reflected on all generated persistence entities and data access objects (E.g. As JavaDoc comments) so that you get access to description of all tables and columns while writing the business logic code

06

Revision Control

Keep track of all changes to database schema and data access layer by viewing the revisions log. Moreover, you can generate code against any revision of the project.

Small Project

  • 5 Tables
  • 10 Columns per Table
  • 20 Operations per Table

Medium Project

  • 20 Tables
  • 25 Columns per Table
  • 50 Operations per Table

Large Project

  • 100 Tables
  • 100 Columns per Table
  • 100 Operations per Table

5 Differences Between Hibernate and Data Access Agility

Data Access Agility is a good alternative to traditional ORMs, such as Hibernate. In this article, we highlight the major advantages of Data Access Agility over traditional ORMs.

Database Transactions

A database transaction is a set of database commands (E.g. Insert, Update, Delete, and Select) that are executed as a single unit of work.