Display member details based on their age using LINQ and Entity Framework

I am trying to check for people in a certain age range. I have two ComboBoxes, minagecombobox and maxagecombobox, with values between 1 and 120.

I want to get the people whose age is between these two values (suppose for example I want to filter out the people aged between 18 and 24).

This is the Member table structure:

member_id
member_firstname
member_dob(datatype is string)

And my entity name i开发者_运维知识库s dbcontext. I am using Entity Framework and LINQ to Entities.

---

Just calculate the age and compare it with your desired age interval. The age calculation isn't exactly the best, but it's good enough as an example:

DateTime now = DateTime.Now;
int min = 18, max = 20;

var res = 
    from m in Member
    let Age = System.Data.Objects.SqlClient.SqlFunctions.DateDiff("y", t.member_dob, now)
    where Age >= min && Age <= max
    select m;

---

DoBConverted = (Today's date - age(in years)) // in datetime

would give you the date of birth.

Simiarly, parse DoB (string) to get datetime.

You can perform a check with dob value with min dob and max dob to get the records.

int minAge = 18, maxAge=20;
DateTime convertedMinDob = DateTime.Now.AddYears(-minAge);
DateTime convertedMaxDob = DateTime.Now.AddYears(-maxAge);
Console.WriteLine(convertedMinDob.ToString() + " " + convertedMaxDob.ToString());

string strDate = "1/1/1995";
DateTime actualDate = DateTime.Parse(strDate);

bool valid = actualDate >= convertedMaxDob && actualDate <= convertedMinDob;

Console.WriteLine(valid? "In range": "Out of range");