public static IQueryable <PackageVersion> GetPackageVersions(DubstatsContext context, string pname)
{
return(context.PackageVersions.FromSqlInterpolated($"SELECT * FROM get_package_version('{pname}')"));
}
public static IQueryable <Package> GetPackageDependenciesAllVersions(DubstatsContext context, string pname)
{
return(context.Packages.FromSqlInterpolated($"SELECT * FROM get_package_dependencies_all_versions('{pname}')"));
}
public Task <Package?> GetPackageAsync([ScopedService] DubstatsContext db, string name) => db.Packages.FirstOrDefaultAsync(p => p.Name == name);
public Task <Package?> GetPackageNameNavigation([ScopedService] DubstatsContext db, PackageDependencyMap map)
{
return(db.Packages.FirstOrDefaultAsync(p => p.Name == map.PackageName));
}
public IQueryable <Package> GetPackages([ScopedService] DubstatsContext db) => db.Packages.OrderBy(p => p.LastUpdate);
