this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[Monet.Models.AgentTransmission]'

asp.net-mvc asp.net-mvc-3 c# entity-framework linq

Question

I have two tables in my SQL database, one for storing the agent (AgentTransmission) and the other logs the transmission history (TransmissionHistory) of the agent (there will only be one successful, or reply status "S", record on the logging table per agent).

I need to grab the information from the AgentTransmission table according to a filter set based on the dates of the TransmissionHistory table. However, since the view I need to send this to is looking for @model IEnumerable<Monet.Models.AgentTransmission> I am getting the following error

The model item passed into the dictionary is of type 'System.Collections.Generic.List1[<>f__AnonymousTypeb'18[System.String,System.String,System.String,System.String,System.String,System.String,System.Int64,System.String,System.String,System.Nullable'1[System.DateTime],System.Boolean,System.String,System.String,System.String,System.String,System.String,System.String,System.Nullable'1[System.DateTime]]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable'1[Monet.Models.AgentTransmission]'.

I'm pretty new to Linq/Entity Framework so if anyone can give me a hint as to what's going on that would be greatly appreciated. Thanks!

        var agents = (from a in db.AgentTransmission
                        join t in db.TransmissionHistory on
                            a.ID equals t.TranTableId
                        where a.RecordStatus.Equals("C") &&
                            a.WelcomeLetter &&
                            t.ReplyResult.Equals("S") &&
                            EntityFunctions.DiffDays(t.TransmittedOn, startDate) <= 0 &&
                            EntityFunctions.DiffDays(t.TransmittedOn, endDate) >= 0
                        select new
                        {
                            a.BankName,
                            a.DRMCompanyName,
                            a.Pendist,
                            a.FirstName,
                            a.LastName,
                            a.MiddleInitial,
                            a.ReferenceNumber,
                            a.AgencyId1,
                            a.AgencyIdType1,
                            a.EffectiveDate,
                            a.JIT,
                            a.Email,
                            a.LocationStreet1,
                            a.LocationStreet2,
                            a.LocationCity,
                            a.LocationState,
                            a.LocationZip,
                            a.CreatedDate
                        });


        return View(agents.ToList());
1
0
8/12/2013 8:22:45 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You are passing an anonymous object to your view (the new {} part of the select) whereas your view expects an object of type IEnumerable<AgentTransmission> (because that's what you used in your @model declaration). You should be coherent in the model you are passing to your view. Ideally design a view model and have your select statement return a new SomeViewModel and then make you view strongly typed to @model IEnumerable<SomeViewModel>.

2
8/12/2013 8:25:32 PM

Popular Answer

As the error is trying to tell you, you declared your view as taking a collection of AgentTransmission.

You can't pass it a collection of anonymous types.

SLaks

Related Questions

The dictionary item supplied in is of type 'System.Collections.Generic.List error'.

The problem is that you have a controller action which passes a ...List<Blog>... instance to a view which is strongly typed to ...IEnumerable<BlogDataEntities>... which is not possible....So you have a controller action like this:...public ActionResult Foo() { List<Blog> blogs = ... return View(blogs); } ...and the corresponding view:...@mo...
asp.net-mvc entity-framework
asked by Darin Dimitrov

Cannot implicitly convert type System.Collections.Generic.IEnumerable<> to bool

Use ...Where ( Any )... in last statement to select customers which have at least one product satisfying your conditions:...var customer = db.GNL_Customer .Where(d => d.GNL_City.FKProvinceID == advancedProvinceID || advancedProvinceID == null) .Where(d => d.FKCityID == advancedCityID || advancedCityID == null) .Where(d => d.FKDepartmentSto...
c# entity-framework
asked by Sergey Berezovskiy

Cannot implicitly convert type 'System.Collections.Generic.List<AnonymousType#1>' to 'System.Collections.Generic.IEnumerable

applicantdata... is ...IEnumerable<APPLICANT>..., in your select statement you are selecting ...anonymous type object... using ...new... keyword, that is why you can't convert it to ...IEnumerable<APPLICANT>.... ...You have to create a temporay class with your properties as in select statement and return ...IEnumerable... of that class. ...Like:...
asp.net asp.net-mvc c# entity-framework linq
asked by Habib

System.InvalidCastException: Unable to cast object of type 'System.Int32' to type 'System.String'

Judging from the exception message your Customer class looks something like this......public class Customer { [StringLength(4)] public int CustomerID { get; set;} } ...Notice that you can't use ...StringLength... on an ...int... property....Get rid of the ...StringLength... and the validation exceptions should go away.
asp.net-mvc entity-framework
asked by Aron

Getting "The entity type <model> is not part of the model for the current context."

This always happened if your repository needs to dynamic accessing different Entity Framework DbContext which means different databases....Check your data connection string in web.config file for each Entity Frmework DbContext....For example:... <add name="CRMEntities" connectionString="metadata=res://*/CRMEntities.csdl|res://*/CRMEntities.ssdl|res...
asp.net c# dbcontext entity-framework put
asked by ChinaHelloWorld

EF6 model first - The entity type is not part of the model for the current context

I am also new to EF, and .NET, but i think that by default EF will search for a connection string with ...the same name as the context's class name..., so, may be, if you change the connection string name to "...TestEntities...", it might do the trick.
entity-framework entity-framework-6
asked by Ghassen Manai

How to use Generic Repository with DDD (Domain Model + Persistence Model)?

This is a difficult question, because you're trying to reconcile two antagonistic approaches to persistence in DDD that were designed by opposite schools of thought....The Generic Repository pattern, considered by some as an ...antipattern..., dates back to early DDD adoption when people were in search of tools and techniques to simplify persistenc...
c# ddd-repositories domain-driven-design entity-framework-6 repository-pattern
asked by guillaume31

Unable to cast object of type 'DBContext.Models.Contact' to type 'System.Data.Entity.Infrastructure.IObjectContextAdapter'

In the ...answer... you have referenced, the answer has this:...var manager = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager; ^^ || see this is db ...That works because the OP in that question has a type which implements the ...
asp.net-mvc-5 c# entity-framework-6 repository-pattern
asked by CodingYoshi

cannot convert from 'System.Collections.Generic.List<object>' to 'System.Collections.Generic.List<DAL.model>'

Instead of selecting ...anonymous... object with ...new { .. }... Try as below with ...new DAL.model() { ... }.......public IQueryable<DAL.model> GetAllmodels() { var models = (from d in db.models where (d.Model_Deleted == false) select ( new DAL.model() { ...
asp.net-web-api entity-framework-6
asked by Karan

How to fix "This dictionary requires a model item of type" in Asp.NET MVC?

You just have to make sure that the model passed in view is compatible(same as passed model) with the model being used inside View,...Compare the namespace where both classes are defined they should be same.Classes should be same...Example:...if you are using...NePisirsem.Models.EntitiyFramework.iletisim...inside view as model then your class ileti...
asp.net-mvc c# entity-framework-6 model-view-controller
asked by TAHA SULTAN TEMURI

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow