If you're a software developer working with databases, you probably needed to create object classes
that represent tables from databases.
This process can consume a lot of time and resources.
Here at CodVerter, we developed an
SQL Table to Entity Class Generator
, that frees you from wasting time on such data manipulation, and lets you focus on
your
code development.
Now you can easily generate an object class in various programming languages from common SQL
databases types.
How Does It Work?
The conversion is based on the 'CREATE TABLE' script and does the following:
- Creates a class named as the table
- Creates class properties for each of the table`s fields with the same names and equivalent data types
- Creates a constructor with all the table`s fields when you mark the "Add Constructor" selection
These programming languages can generate the following as output:
- Properties
- Full Properties
- Fields
- Nullable types declaration (C# and VB)
Extract CREATE TABLE Script
This can be easily done by using the SHOW CREATE TABLE statement, or by using your DB administrator tools.
Generate a C# Class from a Database Table
In C#, most chances you`d encapsulate your class with properties. Generate the class variables as full version properties, short version properties, or only fields.
Generate a C# class from MS-SQL database
Generate a C# class from ORACLE database
Generate a C# class from MYSQL database
Generate a C# class from POSTGRESQL database
Generate a C# class from SQLite database
Generate a Java Class from a Database Table
Java classes are encapsulated with Getters and Setters. Generate the class variables with get and set methods.
Generate a Java class from MS-SQL database
Generate a Java class from ORACLE database
Generate a Java class from MYSQL database
Generate a Java class from POSTGRESQL database
Generate a Java class from SQLite database
Generate a JavaScript Class from a Database Table
For JavaScript (ES5), an object function with a constructor is generated with all of the table`s fields.
Generate a JavaScript class from MS-SQL database
Generate a JavaScript class from ORACLE database
Generate a JavaScript class from MYSQL database
Generate a JavaScript class from POSTGRESQL database
Generate a JavaScript class from SQLite database
Generate a PHP Class from a Database Table
Generate a PHP class from MS-SQL database
Generate a PHP class from ORACLE database
Generate a PHP class from MYSQL database
Generate a PHP class from POSTGRESQL database
Generate a PHP class from SQLite database
Generate a Python Class from a Database Table
For Python, the tool creates a class with _init_() method with all variables and a constructor.
Generate a Python class from MS-SQL database
Generate a Python class from ORACLE database
Generate a Python class from MYSQL database
Generate a Python class from POSTGRESQL database
Generate a Python class from SQLite database
Generate a Scala Class from a Database Table
Scala classes are encapsulated with Getters and Setters. Generate the class variables with get and set methods with optional constructor.
Generate a Scala class from MS-SQL database
Generate a Scala class from ORACLE database
Generate a Scala class from MYSQL database
Generate a Scala class from POSTGRESQL database
Generate a Scala class from SQLite database
Generate a TypeScript Class from a Database Table
Typescript classes are encapsulated with Get and Set methods. Generate the class variables as full version properties or only fields.
Generate a TypeScript class from MS-SQL Database
Generate a TypeScript class from ORACLE Database
Generate a TypeScript class from MYSQL Database
Generate a TypeScript class from POSTGRESQL Database
Generate a TypeScript class from SQLite Database
Generate a VB.NET Class from a Database Table
VB.NET classes are encapsulated with properties. Generate the class variables as full version properties, short version properties, or only fields.
Generate a VB.NET class from MS-SQL Database
Generate a VB.NET class from ORACLE Database
Generate a VB.NET class from MYSQL Database
Generate a VB.NET class from POSTGRESQL Database
Generate a VB.NET class from SQLite Database
We hope you find this useful. Feel free to contact us and to join CodVerter's community.
Let's CodVert!Author: CodVerterTeam
Date: 15 July 2019