User1655654435 posted
The return type of a method that performs a linq query can be IQueryable if you are not sending it to the database yet(it can also be other things).
The purpose of linq is to build a query, meaning build the logic of what you want to do. Then when you are ready to do something with the data, you can execute it by telling it what data you intend to get back(using methods that are "keywords" for that).
like ToList(). The query will then return that type if possible(like IEnumerable).
returns a query without going to db:
public IQueryable<Person> GetSome(string name)
{
return _context.Persons.Where(firstName => firstName.FirstName == name).OrderBy(a => a.Age);
}
builds a query, goes to db to get it and puts it into a list:
public List<Person> GetSome2(string name)
{
return _context.Persons.Where(firstName => firstName.FirstName == name).OrderBy(a => a.Age).ToList();
}
I'm currently learning linq myself. I think that if one is good at it you can become really good at working with databases, doing very effective and low cost data operations.
