How to persist a changes in a DBML (Stored Procedure)

Question

i am using stored procedure and if i add/remove parameters (in the sproc) than when i come to see in dbml than i dont see any changes so what i am doing currently is remove the sproc and added back to dbml designer.

is this a normal behaviour of linqtosql?

in the future if i end-up modify the sproc for some reason do i need to end-up updating dbml also ?

Answer 1

There are a couple of ways of generating Linq To SQL classes from a database, neither of which offers round-trip coding or live update. If you change your database, including sprocs, then you'll need to regenerate your Linq to SQL classes.