EF Core Joins

 public List<MessageViewModel> GetThreadMessages(string id)
        {
            var vm = new List<MessageViewModel>();
            using (ctx)
            {

                var tests = (from m in ctx.Message
                             join u in ctx.User
                             on m.SenderId equals u.Id
                             where m.ThreadId == id
                             orderby m.CreatedOn
                             select new MessageViewModel
                             {
                                 Id = m.Id,
                                 SenderId = m.SenderId,
                                 Username = u.Username,
                                 Text = m.Text,
                                 ThreadId = m.ThreadId,
                                 Time = String.Format("{0:t}", m.CreatedOn)
                             }).ToList();
                vm = tests;

            }
            return vm;
        }