I can’t remember where I found it, but this SQL script will generate a Dapper compatible class file for the table you specify. Also this script is handy to use in the business / mapping layer of you application: SELECT SCHEMA_NAME(SCHEMA_ID) AS [Schema], SO.name AS [ObjectName], REPLACE(p.name, ‘@’, ‘rec.’) + ‘,’ as prop, SO.Type_Desc AS [ObjectType (UDF/SP)], … Continue reading Data Layer Class Generator