Data Access Agility is different from traditional object-relational mapping tools. Data Access Agility allows Java and C# programmers to create highly customized data access layer without writing configuration files, classes, interfaces, or SQL queries; everything is done with an easy to use GUI!
Writing code to manipulate databases has always been tedious and error prone. Let Data Access Agility generate the data access code for you, including schema scripts, persistence entities (models), and data access objects, and focus on what is more important in your application.
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. Everything is done using easy to use GUI.
Stop wasting time writing and fixing data access code! Data Access Agility generates not only database schema scripts but also persistence entities and data access objects. With Data Access Agility, you do not have to write any line of code or SQL query to manipulate the database.
Manipulate database via simple method calls. Data Access Agility provides you with data access objects that expose abstract methods to manipulate the database. As a result, user interface and business logic code will be cleaner and more maintainable.
Tutorial for beginner
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 your database schema using easy to use GUI without regard to database technology
Specify the persistence operations for your application without writing any SQL queries
Download the persistance entities, data access objects, and database schema scripts
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
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.
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
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.
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#.
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
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.
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.
14th June, 2018
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.
18th June, 2018