I have alot of sql in some of my code that i want to switch out to parameterized stored procedures.
I see lots of tutorials out there, just wondering if you have any best practice approachs to recommend, or if there is anything within the entity framework or some microsoft class that would make sense and help.
For example, if you look at this URL https://msdn.microsoft.com/en-us/library/vstudio/zxsa8hkf(v=vs.100).aspx
Its a tutorial for a stored procedure through managed code
Why would you do this vs just writing it directly to the database?
Anyway best advice or approaches would be appreciated.