Working in a MSFT env. Would like your recommendations for a decent C#.NET code generator that will do the following:
Given tables in a schema, generate the stored procs for CRUD operations
Generate the C#.NET class libraries that will use the stored procs to access the data
Is non-ORM-based. i.e. Does not use an ORM like MSFT Entity Framework. I've recently seen a lot of code gens that use it. That's OK. Not judging an ORM or EF here. But our org doesn't use EF and any ORM will be a support issue.
Allow the generated code to be extended. I don't mean modifying the gen'd code. I've used a generator previously that worked with partial classes. Allowed me to extend functionality without affecting the generated code.
Free or low-cost
.NET v3.0, v3.5, or v4.0
Just looking to produce a data access layer DLL based on about 12-15 tables. Would even settle for a gen-once app where it creates the classes the first time and we extend manually.
I've worked with CodeSmith before and working with v7 now. It tends to produce a lot more than we need.
Any others anyone might care to recommend?