Entity Framework 6 - Knowledge Base (KB)

How to convert Linq.ParallelQuery to Linq.IQueryable

var transactions = from t in context.Transactions group t.Create_Date_Time by t.Participation_Id into t1 select new { ParticipationId = t1.Key, CreateDate...

Entity Framework How to bind textbox to model in Windows Forms

Using Entity data model in a Windows Forms Project, I want to bind simultaneously Orders entity to datagridview and to textBox, and textBox has to display OrderID value depending on the current line in the datagrid....The code I used in Form load event i...

With Entity Framework is it better to use .First() or .Take(1) for "TOP 1"?

We are implementing some EF data repositories, and we have some queries which would include ...TOP 1...I have read many posts suggesting to use ....Take(1)... The code I'm reviewing uses ....First()...I understand that both of these produce the same resul...

Linq At least one object must implement IComparable

I am trying to order a List of Entities that contains another list of Entities. I have implemented IComparable for all entities and still get the exception. All of the examples I have seen address the issue where you have one list and you order by a given...

Method cannot be translated into a store expression syntax error

I'm using LINQ to Entity and getting error ...Method cannot be translated into a store expression...var myStrings = from keys in keyTable join values in valuesTable on keys....