I have a C# Application I am creating that stores all data in SQL Server.
Sometimes it's easier for me to make data changes programmatically and sometimes it's easier to have stored procedures and functions in the SQL Server database and call them.
I am rather new to programming and I don't know what the subtle advantages and/or disadvantages of each method are.
I figure I should probably be doing things one way or the other instead of using several methods.
My code is starting to look like a random collection of thoughts all just shoved into one spot. No offense to Joel Spolsky. I love his books.
This is a solo project, so I can refactor any amount of code I want to make it better. All options are on the table.