Problem with Data Repository

Topics: July and December Releases Forum
Apr 23, 2007 at 2:57 PM

I have a problem that has frankly been driving me insane.

I have a number of different project within the solution that connect to various databases. I have 1 project that refuses to play ball. (It is in fact the most simplist project out of all of them).

When ever i try to create the repository for the Data Access layers it's throws up an error:

"There was an error trying to obtain the store procedure result set"

the database it's trying to access only has 1 table and 1 stored procedure, but the table has around 1.4 million records in it.

I click ok and it seems to let me carry on and create the mappings. However when i get to test it through Nunit the IDataReader is always null, which suggests that there could be a problem with the stored procudure, but there isn't as it's been tested through Query Analyser and standard SQL connection and datareader.

this does not occur on any of my other projects files on the solution.

Anyone have any idea what the issue may be? as i'm starting to lose it

thanks in advance.
Apr 23, 2007 at 3:56 PM
turns out to be a currupted system table.