I have a SQL Server grabbing data from a linked Oracle server inside a SP.
On my development server, EF6 insists the SP is returning a
double datatype for one of the columns, but in prod, it insists the same column is a
The SQL Server version is slightly different:
- Prod: 11.0.5582.0
- Dev : 11.0.5613.0
There are no (obvious) differences in how the linked servers are configured (i.e. I've compared the connection properties in SSMS).
Being a new feature, the production database has very few (zero, even) rows in the database, while the dev server has many. I have a feeling that might be related, because I recall having to change the datatype in the middle of development (though I didn't think much of it at the time).
What might be the problem here?