Answers for "sql to c# model"

SQL
0

sql to model c#

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
Posted by: Guest on August-03-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language