Generate C# class from SQL Server table without Store Procedure

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; }
}

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 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

Method 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

   

Method 3

For tables, stored procedures, etc., when you have many POCO to generate:

https://www.codeproject.com/Articles/892233/POCO-Generator

or for simple single queries:

https://visualstudiomagazine.com/articles/2012/12/11/sqlqueryresults-code-generation.aspx

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0