Using variable as database column in EF

Question

How do I use a variable field to access data? I do not know which column I will be searching which is why this is neccessary

db.tbl.FirstOrDefault(r => r.(variable) == "live");

Answer 1

If you would like to select just one or a few properties which map to columns you can do the following;

var emails = context.Person.Select(x => new 
{
    x.Emails
}); 

This returns an collection of object with Email property.

Hope this helps