Cannot be constructed in a LINQ to Entities query. Error

Question

public ActionResult CreateApp(Guid id)
    {

        SMICParkingLotApplicationEntities1 dbb = new SMICParkingLotApplicationEntities1();
        ApplicationDATA applicationData = (from a in dbb.ApplicationDATAs
            where a.ApplicationID == id
            select new ApplicationDATA
            {
                ApplicationID = a.ApplicationID,
                BrandModel = a.BrandModel,
                CrNo = a.CrNo,
                OrNo = a.OrNo,
                DatePosted = a.DatePosted,
                PoR = a.PoR,
                PlateNo = a.PlateNo,
                VehicleType = a.VehicleType

            }).FirstOrDefault();

        ApplicationSlotViewModel applicationSlotViewModel = new ApplicationSlotViewModel
        {
            ApplicationDatas = applicationData,
            Application = new Application()
        };
        return View(applicationSlotViewModel);

Dunno what to do it always shows this error Cannot be constructed in a LINQ to Entities query. Error Help Plss..

possible duplicate:http://stackoverflow.com/questions/5325797/the-entity-cannot-be-constructed-in-a-linq-to-entities-query — octavioccl, Aug 05 '15 at 03:32

Ramireddy Ambati · Answer 1 · 2015-08-05T03:47:29.327

Remove className after new keyword. Try below code.

    var applicationData = (from a in dbb.ApplicationDATAs
        where a.ApplicationID == id
        select new 
        {
            ApplicationID = a.ApplicationID,
            BrandModel = a.BrandModel,
            CrNo = a.CrNo,
            OrNo = a.OrNo,
            DatePosted = a.DatePosted,
            PoR = a.PoR,
            PlateNo = a.PlateNo,
            VehicleType = a.VehicleType

        }).FirstOrDefault();

score 0 · Accepted Answer · edited May 23 '17 at 12:29

0

If the type of ApplicationDatas in your ViewModel is ApplicationDATA, you can set it directly with the result of your query:

var applicationData =dbb.ApplicationDATAs.FirstOrDefault(a=>a.ApplicationID == id);
ApplicationSlotViewModel applicationSlotViewModel = new ApplicationSlotViewModel
{
        ApplicationDatas = applicationData,
        Application = new Application()
};

You can't project the result of your query using an existing entity type. Check the post that I quote in my comment

edited May 23 '17 at 12:29

Community

1
1

answered Aug 05 '15 at 03:45

octavioccl

35,665
6
76
95

IT WORKS! Thank you very much! – Ian Dagalea Aug 05 '15 at 03:56

Cannot be constructed in a LINQ to Entities query. Error

2 Answers2