Hi,

Just wanted to say thanks for the great book. I have one question about your comments on page 35 with regards to using stored procedures .. namely the issues of having to remember to add the SPs appropriately for in the DataContext when the context is refreshed. This would lead me to believe that SPs will entail a higher maintenance effort and potentially higher risk of things going wrong when changes to the DB are made (and thus the Data Context refreshed? What are your recommendations.

Thanks for your feedback.

Regards
Don

Yes, this is another area for much debate. Using inline SQL is easier to deploy but you can leave yourself open to SQL Injection attacks or other attacks if you don't format the SQL correctly. If you know your user base and know they have no idea what a SQL Injection attack is then inline SQL can be easier. You'll lose some performance using inline SQL also but again, it depends on what you're doing. If the site you develop is low volume than it probably doesn't make a difference.

Good luck