Now-a-days most of us works with Entity Framework in, and its quite natual we create and update sprocs on a frequent basis. Here is a core tip that can be considered on a sproc change that contains TEMPERORY tables.

While creating a get procedure which returns data from a temp table, before adding it to the edmx, we need to alter the procedure with the command SET FMTONLY OFF as the first line of the procedure.

Else after adding it in the edmx we can see it retuns not the fields, but an integer variable.

Enjoy Entity framework !

One thought on “TIP : Updating Stored Procedure in EDMX”

  1. Thanks Vishnu for contributing/sharing this. It really helped me very recently too !

Leave a Reply