Entity Framework ExecuteSqlCommand returns -1 while updating table data using stored procedure

Asked Oct 07 '16 at 11:53

Active Oct 07 '16 at 11:59

Viewed 693 times

When I execute

int rowsAffected = db.Database.ExecuteSqlCommand("Update tablename set Column1='new' where id=5")

rowsAffected is number of affected rows.

But when I execute the same statement in a stored procedure:

int rowsAffected = db.Database.ExecuteSqlCommand("spUpdate_tbl");

rowsAffected is returned as -1.

How do I get number of rows affected when updating data using a stored procedure with Entity Framework?

edited Oct 07 '16 at 11:59

marc_s

asked Oct 07 '16 at 11:53

Dnyneshwar

use ExecuteNonQuery, not ExecuteSqlCommand - also see this answer http://stackoverflow.com/questions/10059158/get-affected-rows-on-executenonquery – Darren Wainwright Oct 07 '16 at 12:00
3

My psychic powers are telling me you have the line `SET NOCOUNT ON` in your stored procedure. – asawyer Oct 07 '16 at 12:01
is this `code first` or what ? – Sampath Oct 07 '16 at 14:37

0 Answers0