Entity Framework 6 - Knowledge Base (KB)
839 results in tag: linq
Expression.Invoke in Entity Framework?
The Entity Framework does not support the ...Expression.Invoke... operator. You receive the following exception when trying to use it:..."The LINQ expression node type 'Invoke' is not supported in LINQ to Entities....Has anyone got a workaround for this ...
asked by Brad Leach
LINQ to entities - Building where clauses to test collections within a many to many relationship
So, I am using the Linq entity framework. I have 2 entities: ...Content... and ...Tag.... They are in a many-to-many relationship with one another. ...Content... can have many ...Tags... and ...Tag... can have many ...Contents.... So I am trying to write ...
asked by Phobis
What are the alternatives to using Expand in a LINQ to ADO.net Data Service Query?
I am wondering if there are any alternatives to using the Expand key word when performing an LINQ to ADO.net Data Services query. The expand method does get me the data I am interested in, but it requires me to know all of the sub-objects that I am going...
asked by ChrisHDog
How do I build a Linq Expression Tree that compares against a generic object?
I have an IQueryable and an object of type T....I want to do IQueryable().Where(o => o.GetProperty(fieldName) == objectOfTypeT.GetProperty(fieldName))...so ......public IQueryable<T> DoWork<T>(string fieldName) where T : EntityObject { ... T...
asked by JTew
How do I use a WPF TreeView HierarchicalDataTemplate with LINQ to Entities?
I've got a Page class in my .edmx ADO.NET Entity Data Model file with with Parent and Children properties. It's for a hierarchy of Pages....removed dead ImageShack link - ADO.NET Entity Framework Hierarchical Page Class...This is handled in my SQL databa...
asked by Zack Peterson
WPF TreeView Binding
I've got a class with Parent and Children properties....ADO.NET Entity Framework Hierarchical Page Class http://img148.imageshack.us/img148/6802/edmxxe8.gif...I want to display this hierarchy in a WPF treeview....Here's my XAML......<TreeView Margin="12" ...
asked by Zack Peterson
How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
public static IQueryable<TResult> ApplySortFilter<T, TResult>(this IQueryable<T> query, string columnName) where T : EntityObject { var param = Expression.Parameter(typeof(T), "o"); var body = Expression.PropertyOrField(param,columnName); var sor...
asked by JTew
How do I get the max ID with Linq to Entity?
I have a table User which has an identity column ...UserID..., now what is the correct Linq to Entity line of code that would return me the max ...UserID...?...I've tried:...using (MyDBEntities db = new MyDBEntities()) { var User = db.Users.Last(); ...
asked by Ray
Optimize Group By in LINQ to Entities
I have this query in LINQ to Entities.... var query = (from s in db.ForumStatsSet where s.LogDate >= date1 && s.LogDate <= date2 group s by new { s.Topic.topicID, s.Topic.subject, s.Topic.Forum.forumName, s...
asked by Olaj
Unit testing with Entity Framework
I want to test my Entities that are built using Entity Framework. My concern is that using Entity Framework means directly working with data source. So any ideas how to unit testing Entity Framework based components?
asked by Muhammad Soliman
How do you do a SQL style 'IN' statement in LINQ to Entities (Entity Framework) if Contains isn't supported?
I'm using LINQ to Entities (not LINQ to SQL) and I'm having trouble creating an 'IN' style query. Here is my query at the moment:...var items = db.InventoryItem .Include("Kind") .Include("PropertyValues") ....
asked by JC Grubbs
'Contains()' workaround using Linq to Entities?
I'm trying to create a query which uses a list of ids in the where clause, using the Silverlight ADO.Net Data Services client api (and therefore Linq To Entities). Does anyone know of a workaround to Contains not being supported?...I want to do something ...
asked by James Bloomer
Adding to the Where clause of an Update in LinQ-to-Entities
Let's say I have a table called Product, with three columns: Id, CustomerId, Name. Id is the primary key. The schema is outside of the control of my group, and we now have a requirement to always provide CustomerId as a parameter for all queries (selects...
asked by Joel Martinez
Join and Include in Entity Framework
I have the following query of linq to entities. The problem is that it doesn't seem to load the "Tags" relation even though i have included a thing for it. It works fine if i do not join on tags but i need to do that.... var items = from i in d...
asked by Olaj
Which is the best book out there to learn Linq, including Linq to Entities?
I heard lots of reviews on the book Linq in Action, but it does not cover Linq to Entities. ... Please provide your feedback on the books you may have read.
asked by Binoj Antony
How to create LINQ Expression Tree to select an anonymous type
I would like to generate the following select statement dynamically using expression trees:...var v = from c in Countries where c.City == "London" select new {c.Name, c.Population}; ...I have worked out how to generate...var v = from c in ...
asked by Tom Deloford
Updating your edmx to reflect changes made in your db (.net linq-to-entities)
So I have my edmx made. ...Then I change my database a little bit, changing a column to from being a NOT NULL to allowing NULL....I go into my edmx, right click and choose "Update Model from Database"...Now I go into my program and it hasnt actually upda...
asked by Stuck In Baghdad
Linq-to-entities - Include() method not loading
If I use a join, the Include() method is no longer working, eg:...from e in dc.Entities.Include("Properties") join i in dc.Items on e.ID equals i.Member.ID where (i.Collection.ID == collectionID) select e ...e.Properties... is not loaded...Without the jo...
asked by Lee Atkinson
Instantiating a context in LINQ to Entities
I've seen two different manners that programmers approach when creating an entity context in their code....The first is like such, and you can find it all over the MSDN code examples:...public void DoSomething() { using (TaxableEducationEntities cont...
asked by Jagd
Bulk-deleting in LINQ to Entities
Is there any way to bulk-delete a bunch of objects matching a given query in LINQ or LINQ-to-Entities? The only references that I can find are outdated, and it seems silly to iterate over and manually delete all objects I wish to remove.
asked by Benjamin Pollack
Page 1 of 42
