Selecting Data from Different Databases

Preoncofopelo

New Member
I have two DB's and an application that gets/sets data using an Entity Data Model in VS 2010.I do my full stored procedure in DB(A) and then use the EXEC statement in DB(B) to return the data. The data returns fine and is correct, but whenever I run the program I get the following Exception in C#:The 'AbandonTime' property on 'GetAverageTimes_Result' could not be set to a 'String' value. You must set this property to a non-null value of type 'Decimal'. I have checked everwhere in the Data Model, the values are Decimal and set as nullable etc etc. Even if I change this to any other type or non-nullable value, I still get the same error. It is incredibly frustrating.Any help will be appreciated.
 
Back
Top