EFCore+LINQ 使用DebugView查看LINQ转译后的原生SQL|C/S开发框架

public bool DeletePackageByKeys(List<string> listKeys)
{
    var q = _Database.GetQueryable<sys_UpgraderPackageTable>().Where(w => listKeys.Contains(w.isid));
    _Database.RemoveRange(q);
    return true;
}

var q = _Database.GetQueryable<sys_UpgraderPackageTable>();

if (!String.IsNullOrEmpty(systemName))
{
    q = q.Where(w => (w.SystemName == "*" || (";" + w.SystemName + ";").Contains(";" + systemName + ";")));
}

var qs = q.Select(s => new res_PackageTable
{
    VersionNo = s.VersionNo,
    isid = s.isid,
    SystemName = s.SystemName,
    PackageType = s.PackageType,
    FileVersion = s.FileVersion,
    FileName = s.FileName,
    FileType = s.FileType,
    FileSize = s.FileSize,
    CreationTime = s.CreationTime,
    Remark = s.Remark,
}).OrderBy(o => o.VersionNo);

var list = qs.ToList();