I have a simple table with a primary key in sql 2005 db. If I use the TableAdapter Configuration Wizard in VS2010 to Create New Stored Procedures, it offers by default to generate Insert, Update and Delete stored procedures. I supply the simplest of sql statements for the wizard to generate the rest of the code
SELECT field1, field2
And the wizard only generates code for Insert and Select procedures. The connection is performed with an admin account and I cannot find a reason why the Update and Delete procedures are not generated.
View Complete Post