ApplicationDbContext.AddMessage(Message message);

threadViewModel.Materials = materialsQuery.OrderByDescending(x => x.LastActivity)


.Select(x => new TopicInfoViewModel()
{
    Id = x.Id,
    Title = x.Title,
    MessagesCount = x.Messages.Count(m=>!m.IsDeleted),
    AuthorName = x.Author.UserName,
    PublishDate = x.PublishDate,
    LastMessageId = x.LastMessageId,
    LastMessagePublishDate =
        x.LastMessageId.HasValue ? (DateTime?) x.LastMessage.PublishDate : null,
    CategoryName = x.Category.Name,
    LastMessageAuthorName = x.LastMessage.Author.UserName
})

migrationBuilder.Sql("CREATE TRIGGER ...");

public IReadOnlyCollection<Message> ReadAllPopularMessages(int minPopularity, int pageNumber, int pageSize)
{
    return dbContext.Messages
                    .Include(x => x.Author)
                    .OrderDescending(x => x.Popularity)
                    .Skip(pageSize * (pageNumber - 1))
                    .Take(pageSize)
                    .ToArray();
}

messageRepository.Where(x=>x.Data >= minDate && x.Date <= maxDate)
    .Skip(10).Take(5).Select( x => new { .... })