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.

SQL Table to Class Sample

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
Advanced Options for C#, TypeScript, and VB.NET
These programming languages can generate the following as output:
  • Properties
  • Full Properties
  • Fields
  • Nullable types declaration (C# and VB)
For Java/Scala, it can also auto-generate Getters and Setters.

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!