snickler
commented
6 years ago Hmmm that's a good question. I'll see if I can figure out a way for this to be returned.
Get Outlook for Androidhttps://aka.ms/ghei36
From: Brian MacKay notifications@github.com Sent: Friday, August 10, 2018 8:17:36 AM To: snickler/EFCore-FluentStoredProcedure Cc: Subscribed Subject: [snickler/EFCore-FluentStoredProcedure] Rows Affected (#22)
First off, love this project, thanks for putting it out there.
Here's my question: is there a way to get access to rows affected?
I'm using this in a situation where the sproc is just doing some inserts, but no rows are returned. In this case, SQL Server returns the number of rows affected, but so far I don't see a way to get access to that. It seems like it would be a property on handler:
var result = 0;
db.LoadStoredProc("dbo.sproc_ImportUsers") .WithSqlParam("...", "...") ... .ExecuteStoredProc(handler => { result = handler.RowsAffected });
... Or, perhaps even better, just have ExecuteStoredProc return an int and have an overload that doesn't require the handler parameter:
return db.LoadStoredProc("...").ExecuteStoredProc();
Thanks!
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsnickler%2FEFCore-FluentStoredProcedure%2Fissues%2F22&data=02%7C01%7C%7C76622a2f850b4951bec608d5febb42d3%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636695002579840960&sdata=N9p6VavgM%2FiLJ84XMfx4L0jbMVhvwDEZeoQ5iDJjE7M%3D&reserved=0, or mute the threadhttps://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAD1IpYc4QnHOBfolqoNo64jZdBnzLaSSks5uPXnggaJpZM4V4GdY&data=02%7C01%7C%7C76622a2f850b4951bec608d5febb42d3%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636695002579840960&sdata=qeOq5QmwMmiBH%2FhaT1SDZBKmDPnJgTnBI6KwiC1RGT8%3D&reserved=0.
mooshpot
kinetiq
First off, love this project, thanks for putting it out there.
Here's my question: is there a way to get access to rows affected?
I'm using this in a situation where the sproc is just doing some inserts, but no rows are returned. In this case, SQL Server returns the number of rows affected, but so far I don't see a way to get access to that. It seems like it would be a property on handler:
var result = 0;
db.LoadStoredProc("dbo.sproc_ImportUsers") .WithSqlParam("...", "...") ... .ExecuteStoredProc(handler => { result = handler.RowsAffected });
... Or, perhaps even better, just have ExecuteStoredProc return an int and have an overload that doesn't require the handler parameter:
return db.LoadStoredProc("...").ExecuteStoredProc();
Thanks!