Get inserted/updated/deleted rows count from stored procedure - Linq to SQL?
In your stored procedure you could create a table variable (or temp table if tables variables are not available to you) and insert @@rowcount into it after every part of you stored procedure that affects the row count of a table, then do a select from the table variable as the last operation in your store procedure For example CREATE PROCEDURE myProc AS BEGIN DECLARE @ra TABLE ( rowsAffected INT, queryName VARCHAR(50) ) INSERT INTO sometable SELECT col1, col2 FROM someothertable INSERT INTO @ra (rowsAffected, queryName) VALUES (@@ROWCOUNT, 'insert into sometable') DELETE FROM anothertable WHERE thingID = something INSERT INTO @ra (rowsAffected, queryName) VALUES (@@ROWCOUNT, 'delete from anothertable') SELECT rowsAffected, queryName FROM @ra END Then update your DBML so that the rows are available in Linq to SQL queries.
In your stored procedure you could create a table variable (or temp table if tables variables are not available to you) and insert @@rowcount into it after every part of you stored procedure that affects the row count of a table, then do a select from the table variable as the last operation in your store procedure. For example CREATE PROCEDURE myProc AS BEGIN DECLARE @ra TABLE ( rowsAffected INT, queryName VARCHAR(50) ) INSERT INTO sometable SELECT col1, col2 FROM someothertable INSERT INTO @ra (rowsAffected, queryName) VALUES (@@ROWCOUNT, 'insert into sometable') DELETE FROM anothertable WHERE thingID = something INSERT INTO @ra (rowsAffected, queryName) VALUES (@@ROWCOUNT, 'delete from anothertable') SELECT rowsAffected, queryName FROM @ra END Then update your DBML so that the rows are available in Linq to SQL queries.
I'm calling a stored procedure which does some updates/inserts/deletes (any one of these at a time) from Linq. This stored procedure is added to datacontext I'm using. After calling this stored procedure I want to get the number of rows affected by this stored procedure.
This stored procedure may affect more than one table also. I tried using GetChangeSet method of datacontext but it doesn't return affected rows count for inserts/updates/deletes performed in this stored procedure. I don't want to use @@rowcount and return that rowcount as return value.
Is there any way I can find this affected rows count?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
How to copy an inserted,updated,deleted row in a SQL Server trigger(s)?
How to copy an inserted,updated,deleted row in a SQL Server trigger(s)
Sql trigger (The logical tables INSERTED and DELETED cannot be updated.)?
How to retrieve multiple rows from a stored procedure with Linq to SQL?
How to get the output value from stored procedure from another stored procedure in a tabular format?
How do you get full error information for a stored procedure error out of LINQ-to-SQL or SQL Server?