EFCore中怎么表示Mysql中的三种模糊查询

EFCore中对应Mysql中的三种模糊查询:

  1. Like’%xxx%’:DbContext.TableInfo.Where(p => stringList.Contains(p.id))
  2. Like’xxx%’:DbContext.TableInfo.Where(p => p.Name.StartsWith("XXX"))
  3. Like’%xxx’:DbContext.TableInfo.Where(p => p.Name.EndsWith("XXX"))