Entity Framework 6 - Knowledge Base (KB)

If I select from an IQueryable then the Include is lost

The ...include... does not work after I perform a select on the ...IQueryable... query. Is there a way around this? My query is...public IQueryable<Network> GetAllNetworks() { var query = (from n in _db.NetworkSet .Include("NetworkCont...

Create a lambda expression with a new anonymous type at runtime

I want to invoke a method that expects a parameter like this:...Expression<Func<sometype, 'a>> expr ...I need to construct this parameter at runtime, because I won't know what the anonymous type will look like before; it could have any amount of fields:..

Cannot implicitly convert anonymous type #1[] to anonymous type #2[]

I have following scenario:...public JsonResult ChangeFilterList(int option) { var data = new[] { new { Text = "Unknown option", Value = -1 } }; switch (option) { case 2: data = _departmentnameRepository.All.Select(x => new { Text = x.D...

Anonymous type result from sql query execution entity framework

I am using entity framework 5.0 with .net framework 4.0 code first approach. Now i know that i can run raw sql in entity framework by following ...var students = Context.Database.SqlQuery<Student>("select * from student").ToList(); ...It's working perfect...

The type appears in two structurally incompatible initializations within a single LINQ to Entities query

I'm trying to build something like conditional queries to get only needed data from the underlying database....Currently I have the following query (which works fine)...var eventData = dbContext.Event.Select(t => new { Address = true ? new Ano...

Cannot be inferred from the usage. Try specifying the type arguments explicitly

I want to make a projection as a performance wise but the select part returns an anonymous type and I can't to make required mapping.... var jobDegreesQuery = _context.JOBDEGREEs.AsQueryable().Select(d=> new {d.DEGREE_CODE,d.DEGREE_NAME }); i...