The data reader is incompatible with the specified Model

Question

User450763225 posted

Hi, Guys, I got this below error when using EF6 and some sql queries. It should be very simple retrieve operation from the mapping. I attached the code causing this issue and the error message.

private Service_PerformaceEntities db = new Service_PerformaceEntities();

        // GET: api/RTC_Resource_
        /* public IQueryable<RTC_Resource_> GetRTC_Resource_()
         {
             return db.RTC_Resource_;
         }*/
        string sql = "select count(*) as Amount, [Owned By] as Owner from RTC_Resource$ group by[Owned By] order by Amount";

        public List<RTC_Resource_> GetRTC_Resource_()
        {
            return db.RTC_Resource_.SqlQuery(sql).ToList();
        }

{"Message":"An error has occurred.","ExceptionMessage":"The data reader is incompatible with the specified 'Model.RTC_Resource_'. A member of the type, 'Id', does not have a corresponding column in the data reader with the same name.",

Answer 1

User753101303 posted

Hi,

And what is the class declaration for RTC_Resource_? Don"t you have an Id property which you don't read as told by the error message?

Answer 2

User450763225 posted

I did have ID column set up in the mapping. not sure why it said so.

Actually, the problem is when I returned the whole result without sql query, it worked fine. so something wrong the returned dataset.

Answer 3

User-271186128 posted

Hi sdnd2000,

According to your code and description, I suggest you could try to use the following code:

        public List<RTC_Resource_> GetRTC_Resource_()
        {
            List<RTC_Resource> list = (from cc in db.RTC_Resource_.SqlQuery(sql)
                                        select new RTC_Resource
                                        {
                                           property1 = cc.Owner,
                                           property2 = cc.Amount
                                        }).ToList(),
            //property1 and property2 are the fields in the RTC_Resource

            return list;
        }

Best regards,
Dillion

Answer 4

User450763225 posted

Hi, I have solved this problem, it is caused by different entity mapping. Thanks so much.