static void Main(string[] args) { Seeder.Seed(); var query = dbContext.Authors.Include(x => x.Posts).Select(x => new ViewModels.Author { Id = x.Id, Name = x.Name + " " + x.LastName, Posts = x.Posts.Select(y => y.Id).ToList() }).Where(authorView => authorView.Id != 5) .OrderBy(autoryView => autoryView.Name) .ToArray(); //var query = dbContext.Posts.Where(x => x.Content.ContainsText("egg")).ToArray(); var john = dbContext.Authors.First(x => x.LastName == "Doe"); var post = dbContext.Posts.Where(x => x.Title == "John Second Post Title").Include(x => x.Author).First(); Console.WriteLine(post.Author == john); var textContains = dbContext.Posts.Where(x => !x.Content.ContainsText("egg")).ToArray(); }