CODEWITHSUNDEEP
c#asp.net-mvc
HarshSharma
HarshSharma

Reputation: 660

The model item passed into the dictionary is of type 'System.Data.Entity.Infrastructure.DbQuery', but this dictionary requires a model item of type B

I been stuck in a situation and I tried finding the solution for it on net but was not successful. I am new to MVC with Entity Framework, and it is throwing the exception when i try to run the application:

The model item passed into the dictionary is of type 'System.Data.Entity.Infrastructure.DbQuery1[<>f__AnonymousType12[UnRelatedEntity.Models.t_AbortReason,UnRelatedEntity.Models.t_Activity]]', but this dictionary requires a model item of type 'UnRelatedEntity.Models.MobilePhoneXchangeEntities1'

I am using an Entity as a model which fetches Data from two tables seperately which do not have relation among them.

Controller:

public ActionResult Index()
{
    MobilePhoneXchangeEntities1 ent = new MobilePhoneXchangeEntities1();
    var result = from foo in ent.t_AbortReason
                 from bar in ent.t_Activity
                 where foo.AbortReasonCategoryId != null && bar.ActivityId != null
                 select new { Foo = foo, Bar = bar };
    return View(result);
}

View

@model UnRelatedEntity.Models.MobilePhoneXchangeEntities1

In the view I am just writing the above line i mean i am just inheriting the Model, nothing else but still I am confused about how to type cast model w.r.t model, but I am helpless.

Can anyone please provide me help on this, but please keep in mind i am using two unrelated tables in my model.

Upvotes: 4

Views: 33253

Answers (6)

Gabriel Arghire
Gabriel Arghire

Reputation: 2360

You are trying to insert an exception into your database.

To see the exact error(s), you should have something like this:

private DbCtx db = new DbCtx();

try
{
    ctx.SaveChanges();
    base.Seed(ctx);
}
catch (DbEntityValidationException ex)
{
    string errorMessages = string.Join("; ", ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.PropertyName + ": " + x.ErrorMessage));
    throw new DbEntityValidationException(errorMessages);
}

where DbCtx is a your database building class.

Upvotes: 0

Ramon robles
Ramon robles

Reputation: 1

Add a new object or instance with the correct type

@Html.Partial("_LoginPartial", new MVCTest.Models.LoginViewModel())

Upvotes: 0

muthukmar
muthukmar

Reputation: 1

The model item passed into the dictionary is of type 'Person.Models.Location', but this dictionary requires a model item of type 'Person.Models.LoginModel'.

Upvotes: 0

Mikael Puusaari
Mikael Puusaari

Reputation: 1034

None of the answers worked for me, but in the end, for some reason, EF 6 seemed to interpret this as a query:

var patient = db.Patient.Where(p => p.ID == id);

while this returned the Model I needed and works for me:

var patient = db.Patient.Where(p => p.ID == id).FirstOrDefault();

Upvotes: 3

Shad
Shad

Reputation: 4464

Your view expects model of type UnRelatedEntity.Models.MobilePhoneXchangeEntities1, but you pass result object to it. result is a database query, which you have described in controller action. So, you get expected error - type mismatch.

To fix this you should create type for your query items. Very simple example:

public class ResultItem
{
    public Foo Foo { get; set; }
    public Bar Bar { get; set; }
}

After that modify select statement in your query:

select new ResultItem { Foo = foo, Bar = bar };

and in the end, change model type of the view to IEnumerable<ResultItem>, because query will return collection of result items.

Upvotes: 1

nick_w
nick_w

Reputation: 14938

As Shad points out, the reason you are getting this error is simply because you are passing a different type of data into the view than what you have said you would.

To solve this, you need a model that you can pass into your view that holds the data you need: 

public class FooBarModel
{
    public AbortReason Foo { get;set;}
    public Activity Bar { get;set;}
}

Then, in your Index method, do something like this:

using(MobilePhoneXchangeEntities1 ent = new MobilePhoneXchangeEntities1())
{
    var result = from foo in ent.t_AbortReason
                 from bar in ent.t_Activity
                 where foo.AbortReasonCategoryId != null && bar.ActivityId != null
                 select new FooBarModel() { Foo = foo, Bar = bar };
    return View(result);
}

And in your view, set the model type:

@model IEnumerable<my.namespace.FooBarModel>

Upvotes: 6

Related Questions