Hi, All of you. I am creating one application for demo purpose using WEB API 2, SQL Server 2012 and EF 6.
I want perform all CRUD operation using single Stored Procedure. When I write single Stored Procedure for Perform all CRUD operation I am unable to perform it.
But if I use saperate Stored Procedure for all CRUD operations am able to do this.
First of all I want to know Is it possible to perform all CRUD operations using Single Stored Procedure?
If yes, Please suggest me the way.
Thank you.