Eugene Myasyshchev gemyago

gemyago / generate_dto.sql

Last active September 4, 2023 20:23

TSQL script to generate POCO/DTO from database table

	DECLARE @tableName NVARCHAR(MAX), @schemaName NVARCHAR(MAX), @className NVARCHAR(MAX)

	--------------- Input arguments ---------------
	SET @tableName = 'Incidents'
	SET @schemaName = 'dbo'
	SET @className = 'IncidentDto'
	--------------- Input arguments end -----------

	DECLARE tableColumns CURSOR LOCAL FOR
	SELECT cols.name, cols.system_type_id, cols.is_nullable FROM sys.columns cols