Stored Procedure successfull execution using LINQ

Question

I'm updating some value through stored procedure using LINQ. How would I be able to know that the updation has been performed successfully on table like we got to know in ADO.net where ExecuteNonQuery() Function returns the no of affected values.

Suthish Nair · Answer

refer blog check What Happens if the SPROC Throws an Error?

Vahaj uddin · Answer

@Sam I don't know you are not getting my English or what. Amit posted the URL which is about retrieving data through stored procedure using LINQ. And I clearly mentioned that I'm updating some thing(Not retrieving), I'm updating some column value and how would be I able to know how many rows have been updated successfully. In ADO.net we used to do that int i = commandObject.ExecuteNonQuery(); If i=0 that means no row updated if i>=1 that means 1 or more then 1 rows have been updated successfully. I also need the same functionality (That I mentioned above) while using LINQ. Did u get now??

Sam Hobbs · Answer

Your question is vague. Amit tried to help. You will get a more accurate answer with a more accurate question. What specifically do you do that you need to know is successful?

Vahaj uddin · Answer

Its not the same thing that I asked. I was asking how to know that stored procedure has successfully performed DML operation like insert, update and delete. How we are able to know that stored procedure inserted 1 row 2 rows or 3 rows.

Amit Choudhary · Answer

Hi friend, Here is the right thing you should go through how to use stored procedure using the LINQ. http://www.c-sharpcorner.com/UploadFile/dhananjaycoder/4913/Default.aspx Thanks

Stored Procedure successfull execution using LINQ

Answers (5)