Generate C# class from SQL Server table without Store Procedure [duplicate]

Question

Is there any way to generate a class for table in SQL Server without adding table in project with ADO.net Entity Framework?

public class Approval
{
        public long Id { get; set; }
        public long? FormId { get; set; }
        public long? DesignationId { get; set; }
        public DateTime? CreatedOn { get; set; }
}

Answer 1

This online tool generates a class from SQL table. Class is based on the CREATE TABLE script in MS-SQL, ORACLE, MYSQL, POSTGRESQL and SQLite databases, to a class in C# and other programming languages.

https://codverter.com/src/sqltoclass

Answer 2

If you want to use Entity Framework you should consider to use Database First approach.

Other simple and fast way to import a Sql Server scheme to a class in VS is this:

1. Make a select as json query:

   SELECT * FROM Approval 
   FOR JSON AUTO
   

2. Copy one row from the result in your clipboard:

   [
     {"Id":1, "FormId":10, "DesignationId":100, "CreatedOn":"2000-01-01T00:00:00"},
     {"Id":2, "FormId":20, "DesignationId":200, "CreatedOn":"2000-01-01T00:00:00"}
   ]
   

3. Paste in Visual Studio: Edit > Paste Special > Paste JSON As Classes