Skip to content

Instantly share code, notes, and snippets.

@gionnani
gionnani / ClassGenerator.sql
Last active July 24, 2019 12:03 — forked from ernado-x/ClassGenerator.sql
Generate C# class from database table
--modified from SO: http://stackoverflow.com/questions/5873170/generate-class-from-database-table
--added table and column
declare @TableName sysname = 'TableName'
declare @Result varchar(max) = '[Table(Name = "' + @TableName + '")]
public class ' + @TableName + '
{'
select @Result = @Result + '
[Column(DbType = "' +