Option to Generate Parameterized Queries instead of Sprocs?

Developer
Aug 24, 2007 at 1:57 PM
Are there any plans to create an option that instead of using stored procedures would generate the parameterized queries in the code?

This would be beneficial in a few ways:

1) Offer a bit more rapid application development by not having to generate sprocs in development mode.
2) Make it available for use when you do not have the option of modifying the legacy database.
3) Keep from having to maintain stored procs for simple CRUD scenarios.

I added a workitem for voting:

Generate Parameterized Queries instead of Stored Procedures Option

Regards,

Dave

_____________________________________

David Hayden
Microsoft MVP C#
Aug 24, 2007 at 6:54 PM
Agreed, it would be a nice addition. We'll have to see where it lands in the voting to see if we implement it or leave it to the community.