Generic update Stored Procedure for Table
Posted on 2014-04-07
I have an application where I am using table adapters with MSSQL.
I want to create an update method whereby I can update only the passed variables;
for example take the following table;
i would like to create a generic update method whereby i may only pass the email and the id to update the surname. (To not the update method on my table adapter is not created automatically as it has a join across two tables).
Is it better to use the table adapter or would you recommend creating a stored procedure for this?
Would it be possible for an example update stored procedure in this case as SQL is not my strong point.