Stored procedure returns int instead of result set

by

I get this when I have a stored procedure that includes an “exec” call into a temporary table, such as:

insert into #codes (Code, ActionCodes, Description)
exec TreatmentCodes_sps 0

It appears that Entity Framework gets confused as to what should be returned by the procedure. The solution I’ve come across is to add this at the top of the sproc:

SET FMTONLY OFF

After this, all is well.

More Related Contents:

  1. Fastest Way of Inserting in Entity Framework
  2. Entering keys manually with Entity Framework
  3. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. LINQ to SQL multiple tables left outer join
  6. Entity Framework error: Cannot insert explicit value for identity column in table
  7. Entity Framework. Delete all rows in table
  8. Entity Framework – stored procedure return value
  9. EF 6 Parameter Sniffing
  10. Retrieve an object from entityframework without ONE field
  11. Join and Include in Entity Framework
  12. Anonymous type result from sql query execution entity framework
  13. Calling a SQL User-defined function in a LINQ query
  14. How to use String property as primary key in Entity Framework
  15. Querying data using Entity Framework from dynamically created table
  16. Taking lot of time to read from SQL Server using c#
  17. Delete from two tables? [closed]
  18. SQL Date format BETWEEN query
  19. Circular reference detected exception while serializing object to JSON
  20. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  21. Is it necessary to manually close and dispose of SqlDataReader?
  22. Linq to EntityFramework DateTime
  23. Entity Framework with XML Files [closed]
  24. The operation cannot be completed because the DbContext has been disposed error
  25. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  26. Table name and table field on SqlParameter C#?
  27. Autonumber with Entity Framework
  28. Entity framework: StoreGeneratedPattern=”Computed” property
  29. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  30. Why is EF returning a proxy class instead of the actual entity?

Leave a Comment