How to write a select year(max(datefield) in EntitySQL in c# entity framework

Retrieve your eventdates (here it is a list), extract the year from the dates, and find the maximum year:

List<DateTime> list = new List<DateTime>();
list.Add(new DateTime(2012, 2, 3));
list.Add(new DateTime(2011, 12, 23));
list.Add(new DateTime(2014, 10, 5));
list.Add(new DateTime(2013, 4, 13));

int year = list.Select(d => d.Year).Max();  

Console.WriteLine("Max. year: " + year.ToString());

// Result: Max. year: 2014

Select allOpen in new window

Or, with no Lambda:

int year = (from d in list select d).Max().Year;

Select allOpen in new window

/gustav

I am getting the date from a database query. Normally I would do something like

ste is a reference to entities

var varDate =( from d in ste.TurtleEvent
                         select d)
however, that gets me a whole row. How do I populate the list you propose from a database query where the date field is a sql datetime?

Hi,
Pls try this..

TurtleEvent.Eventdate.MAX().ToString("YYYY")

Select allOpen in new window

Hope it helps!

That would be:

DateTime maxDate = (from event in ste.TurtleEvent select event.eventdate).Max();

Select allOpen in new window

or:

int year = (from event in ste.TurtleEvent select event.eventdate).Max().Year;

Select allOpen in new window

/gustav

When I try either of these I get an error saying that "from" does not exist in this context. It seems that the "from" syntax only works with a var.

Hi,
Any luck with mine?

Thank you.
Pawan

Then try with the Lambda syntax:

int year = ste.TurtleEvent.Select(d => d.Year).Max();

Select allOpen in new window

Or perhaps something else is going on.

/gustav

Pawan, in what context would this go.  TurtleEvent.Eventdate.MAX().ToString("YYYY"). ?

Hi,
Pls try like..

int year = ste.TurtleEvent.Eventdate.MAX().Year;

Select allOpen in new window

Hope it helps!

thanks, that helps a lot.

You are welcome!

/gustav