msdn magazine: stored procedures using .net – parte I
this article was published in edition 21st of msdn magazine in brazil.
most part of security articles suggest using store procedures instead of access the table in the database directly. however, some people ask if there are additional advantages in using them. some people defend religiously their opinions about using or not stored procedures. however, my objective in this article was not take any side of this war. my objective was help you to use them in the best way and also some features of visual studio, in case if you decide to use store procedures. in the first part of this tutorial, i showed what a stored procedure is and its advantages. i showed step-by-step how to write it using the visual studio. in the second article i showed how to access the stored procedure using ado.net.