NET问答: LINQ 中为啥不能将 StartsWith() 转成 Like('abc%') ?

咨询区 Techy：我有下面的一段 asp.net core LINQ 代码。   List results = await db.ApplicationUsers.Where(u => u.Name.StartsWith(name) && !u.Deleted && u.AppearInSearch)                                    .OrderByDescending(u => u.Verified)                                    .ThenBy(u => u.DateAdded) // Added to prevent duplication of results in different pages                                    .Skip(page * recordsInPage)                                    .Take(recordsInPage)                                    .Select(u => new UserSearchResult()                                    {                       ………………………………