Generate C# class from SQL Server table without Store Procedure

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

you can use database first approach which will create a diagram and then all classes — Budyn, Sep 07 '18 at 15:22
What problem are you *actually* trying to solve? You have already created a class to model the table you show. — Dan Wilson, Sep 07 '18 at 15:23
I am using store procedure to get data and in razor view i want to refer a class of store procedure like @model Brass.Models.EmployeeClass so i want a easy way to generate class dont want to use long procedure like code first approch — Waqas Nawaz Warraich, Sep 07 '18 at 15:24
@MaxVernon: Does Dapper have a tool to create a POCO type from a table or query? I had a tool I wrote in a previous job (that extracted metadata from a Data Reader), but, alas, I don't work there anymore. — Flydog57, Sep 07 '18 at 15:57
I'm curious about this too, but for stored procedures. I'd like to somehow return the column data types from a SP and turn it into a POCO. — jon.r, Sep 07 '18 at 16:20
@Flydog57 - actually I don't think it does. I'll remove my comment. — Hannah Vernon, Sep 07 '18 at 16:26
Look here: https://gist.github.com/halityurttas/17e36d2fa047b925ccef7940d451083e — bugnuker, Sep 07 '18 at 16:36
Copy 1 Row of output (with header) and paste here to [Generate Class from CSV](https://toolslick.com/generation/code/class-from-csv) — KyleMit, Aug 26 '20 at 01:56
Open Package Manager Console and type this: `Scaffold-DbContext "Server=servername.com;Database=My_Db;Trusted_Connection=True;MultipleActiveResultSets=true;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir "Models/Entities" -DataAnnotations -Tables Approval`. Source: https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding/?tabs=vs. — Ash K, Dec 19 '22 at 21:56

Jonathan Applebaum · Accepted Answer · 2019-08-11T05:46:21.773

59

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

edited Aug 11 '19 at 05:46

answered Jul 09 '19 at 15:58

Jonathan Applebaum

5,738
4
33
52

Great we find I was using a .net desktop app but it always froze i love these online tools nice work if it is use. – c-sharp-and-swiftui-devni Jul 22 '19 at 10:02
1

Awesome! I didn't feel like typing out a really long class. This tool saved me 10 min! – Robert Stokes Nov 06 '19 at 14:44
If you do not want to use online tool ,use store procedure in following post https://stackoverflow.com/questions/5873170/generate-class-from-database-table – Waqas Nawaz Warraich Feb 12 '20 at 07:04
2

@WaqasNawazWarraich Thank you for the link. BTW, from a security point of view, All the data entered to the editors is interpreted and converted only on the client-side (using Angular and Typescript) and never sent back to the server (full disclosure - I am the developer of this tool). – Jonathan Applebaum Feb 12 '20 at 16:30
@jonathana no doubt your tool is very helpful and user friendly, Well done – Waqas Nawaz Warraich Feb 13 '20 at 03:27
1

bigint nullable columns are not generated with "?" – Sparrow Mar 03 '20 at 06:48
Great tool. Added to my favorites. – John Prado Mar 24 '21 at 23:35
What a great tool. Thank you for sharing and thank you to the devs! – Dowlers Jul 30 '22 at 03:13

score 29 · Answer 2 · edited Aug 26 '20 at 01:40

29

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

edited Aug 26 '20 at 01:40

KyleMit

30,350
66
462
664

answered Oct 24 '18 at 17:22

Alpha75

2,140
1
26
49

JSON is only supported in MSSQL 2016+. But Paste as XML works great in MSSQL 2008+. – MTAdmin Dec 17 '18 at 23:23
am on 2019 have they removed this now ?. – c-sharp-and-swiftui-devni Jul 22 '19 at 13:58
@rogue39nin it's still under Edit in VS2019, but not there if you "right-click". – Kijana Woodard Aug 30 '20 at 16:54
This works great but it doesn't work until you have data. I just built the table and I don't want to go through the trouble of adding data. – RoLYroLLs Sep 11 '20 at 13:49