See, stored procedure in DB means storing small database handlers into DB directly. This ensures two things, 1. Make the retrieval/insertion/any db operation faster; 2. security of SQL.
At this stage we do not want to write any SQL inline (means not within C# Code). Now the question is how to write stored procs in SQL Server? How to call the proc from within your code?
At this stage we do not want to write any SQL inline (means not within C# Code). Now the question is how to write stored procs in SQL Server? How to call the proc from within your code?