CRUD operations in Linq To SQL using single stored procedure

Akaash Chintamani Meher

11y1.2kLINQ

Please let me know how can i do CRUD opertaions using LINQ to SQL in a single stored procedure(in that stored procedure all crud operations written).

Please reply asap. its urgent......

Thanks.....

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted answer
As per your need, you need to modify the Stored Proc; You need to assign default value to SP parameters like below:

CREATE PROCEDURE usp_CRUD
(@type char(1), @id int = 0, @name varchar(50) = '')
AS
BEGIN
-- Implement yourown logic
END
+2
Manas Mohapatra10y ago
This thread is different than your original thread. Create another thread for this.

Thank you.
+1
Akaash Chintamani Meher10y ago
Hi Manas, Hope u r doing well. Can u pls explain what is the diff between httphandler and httpmodule with example?
0
Akaash Chintamani Meher11y ago
Okay
0
Manas Mohapatra11y ago
What happen. If you need any help you can post it here... You can message in fb, gmail, that present c# corner profile..
+1
Akaash Chintamani Meher11y ago
Hi Manas, Can u pls tell me ur email id?
0
Akaash Chintamani Meher11y ago
Thanks Manas......
0
Akaash Chintamani Meher11y ago
Hi Manas,

Thanks for your polite response.
I agree with you on the above code for Insert and Update. But what about the 'Select' and 'Delete'?
How can we pass the parameters in front end whereas 3 parameters are mandatory.

Please reply with your valuable answer.

Thanks.
+1
Manas Mohapatra11y ago
Stored procedure

CREATE PROCEDURE usp_CRUD
(@type char(1), @id int = 0, @name varchar(50) = '')
AS
BEGIN
   IF(@type = 'C')
   BEGIN
      INSERT INTO EMP(@id, @name);
   END
   ELSE IF (@type = 'R')
   BEGIN
      SELECT * FROM EMP WHERE id = @id;
   END
   ELSE IF (@type = 'R')
   BEGIN
      UPDATE EMP SET name= @name WHERE id = @id;
   END
   ELSE IF (@type = 'D')
   BEGIN
      DELETE FROM EMP WHERE id = @id;
   END
END

Linq to SQL

CustomersDataContext ctx = new CustomersDataContext();
// Create records in DB
ctx.usp_CRUD('C', 1, 'your name');

// Update records in DB
ctx.usp_CRUD('U', 1, 'your name');
+2