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?
enter image description here
public class Approval
{
public long Id { get; set; }
public long? FormId { get; set; }
public long? DesignationId { get; set; }
public DateTime? CreatedOn { get; set; }
}
Sep 2018 - Waqas Nawaz Warraich
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
enter image description here
Jul 2019 - jonathana
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:
Make a select as json query:
SELECT * FROM Approval
FOR JSON AUTO
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"}
]
Paste in Visual Studio: Edit > Paste Special > Paste JSON As Classes