Entity Framework not getting column info on a diff

问题:

I am having trouble getting column information on a different schema.

It was working fine until we changed the connection string.

default schema is [dbo] the newly adding stored procedure is in "different_schema"

Does anyone know and had the same experience on this issue?

Thank you in advance.

回答1:

At the start of the stored proc temporarily add

SET FMTONLY OFF

to get the column information returned.

This is explained well here