Tip: While Updating Edmx file

While creating a get procedure that 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s