SyntaxFix

[linq] How to Select Min and Max date values in Linq Query

If you are looking for the oldest date (minimum value), you'd sort and then take the first item returned. Sorry for the C#:

var min = myData.OrderBy( cv => cv.Date1 ).First();

The above will return the entire object. If you just want the date returned:

var min = myData.Min( cv => cv.Date1 );

Regarding which direction to go, re: Linq to Sql vs Linq to Entities, there really isn't much choice these days. Linq to Sql is no longer being developed; Linq to Entities (Entity Framework) is the recommended path by Microsoft these days.

From Microsoft Entity Framework 4 in Action (MEAP release) by Manning Press:

What about the future of LINQ to SQL?

It's not a secret that LINQ to SQL is included in the Framework 4.0 for compatibility reasons. Microsoft has clearly stated that Entity Framework is the recommended technology for data access. In the future it will be strongly improved and tightly integrated with other technologies while LINQ to SQL will only be maintained and little evolved.

Examples related to linq

• Async await in linq select • How to resolve Value cannot be null. Parameter name: source in linq? • What does Include() do in LINQ? • Selecting multiple columns with linq query and lambda expression • System.Collections.Generic.List does not contain a definition for 'Select' • lambda expression join multiple tables with select and where clause • LINQ select one field from list of DTO objects to array • The model backing the 'ApplicationDbContext' context has changed since the database was created • Check if two lists are equal • Why is this error, 'Sequence contains no elements', happening?

Examples related to linq-to-sql

• Understanding SQL Server LOCKS on SELECT queries • how to update the multiple rows at a time using linq to sql? • LINQ: combining join and group by • LINQ to SQL: Multiple joins ON multiple Columns. Is this possible? • How to Select Min and Max date values in Linq Query • How to do a LIKE query with linq? • How to do a join in linq to sql with method syntax? • How to store a list in a column of a database table • Returning IEnumerable<T> vs. IQueryable<T> • Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?