The data reader returned by the storage data provider does not have enough columns for the requested query

0

Greetings.

In Entity Framework, when I try to make an insert, it sends me the following message:

  

The data reader returned by the storage data provider does not have enough columns for the requested query.

However, the registration is saved. This happens only sometimes, not always. I have not found an answer that works for me on the Internet.

Could you help me explain what this error is about? And if you send an error, why is the record being saved?

Thanks for your time.

    
asked by Naroh 02.03.2017 в 20:00
source

1 answer

0

I do not know if it will still work for you or if it will fit your case, but it was happening to me and I was going crazy and in the end I found that a table that I modified in the procedure had a trigger that was the one that really had problems . If that is the case, review it. The problem came from a trigger prepared for a single record change but several were being eliminated (when comparing with INSERT or DELETE it is necessary to change the "=" to "IN").

I hope it will help you, or help others with the same case;)

    
answered by 30.01.2018 в 14:31