Entity Framework学习三：查询、插入、更新和删除操作

var query = from person in context.People
                        where person.FirstName.StartsWith("a")
                        select person;
var methodQuery = context.People.Where(p => p.FirstName.StartsWith("a"));

var query = from person in context.People
                        where person.FirstName.StartsWith("a") &&
                        person.LastName.EndsWith("b")
                        select person;
var methodQuery = context.People.Where(p => p.FirstName.StartsWith("a") && p.LastName.EndsWith("b"));

            var query = from person in context.People
                        where person.FirstName.StartsWith("a") &&
                        person.LastName.EndsWith("b")
                        orderby person.FirstName,person.LastName
                        select person;
            var methodQuery = context.People
                .Where(p => p.FirstName.StartsWith("a") && p.LastName.EndsWith("b"))
                .OrderBy(p => p.FirstName)
                .ThenBy(p => p.LastName);