Entity Framework 6 - Knowledge Base (KB)

Select Max in Linq to Entities / Entity SQL with type conversion

I'm trying to create some CRUD functionality for a legacy database and using the Entity Framework as an ORM tool. One table, 'Sites', has a Guid type 'Id' column which is never seen by the users and an integer type 'SiteId' which the users use to identitf...

How to get max value of a column using Entity Framework?

To get maximum value of a column that contains integer, I can use the following T-SQL comand...SELECT MAX(expression ) FROM tables WHERE predicates; ...Is it possible to obtain the same result with Entity Framework....Let's say I have the following model....

Using max() function with entity framework throws an exception

So I need to get the max value of a column (or the last one) using entity framework and both of these queries throw exceptions:...(The ID I'm trying to retrieve is of type varchar, but it works in raw sql, I think it should work here too)...This one:...st...

How to get in LINQ one row for each key

I have list with:...EMP_ID | UPDATED_DATE | MARK ------ | ------------ | ---- 111 | 01/01/2015 | 99 111 | 01/01/2013 | 85 111 | 01/01/2017 | 80 222 | 01/01/2011 | 70 222 | 01/01/2015 | 55 222 | 01/01/2002 | 60 ...