CRUD operations in Linq To SQL using single stored procedure

Question

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.....

Manas Mohapatra · 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

Manas Mohapatra · Answer

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');

Manas Mohapatra · Answer

This thread is different than your original thread. Create another thread for this. Thank you.

Manas Mohapatra · Answer

What happen. If you need any help you can post it here... You can message in fb gmail that present c# corner profile..

Akaash Chintamani Meher · Answer

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.

Akaash Chintamani Meher · Answer

Hi Manas Hope u r doing well. Can u pls explain what is the diff between httphandler and httpmodule with example?

Akaash Chintamani Meher · Answer

Okay

Akaash Chintamani Meher · Answer

Hi Manas Can u pls tell me ur email id?

Akaash Chintamani Meher · Answer

Thanks Manas......