C# IQueryable.AsEnumerable方法代码示例

 private void RefillAssociations(object sender, EventArgs e)
 {
     int catID = 0;
     try
     {
         catID = (int)cb_cat.SelectedValue;
     }
     catch (InvalidCastException)
     {
         return;
     }
     TCatParameters.Clear();
     Parameters =
     from PC in database.ParameterCategorySet
     select new AssociatedPC
     {
     id = PC.id,
     name = PC.name,
     type = PC.type,
     associated = (from ICPC in database.pureJoin_IPcatsSet where ICPC.PCID == PC.id && ICPC.ICID == catID select ICPC).Any()
     };
     foreach (var par in Parameters.AsEnumerable())
     {
         DataRow nrow = TCatParameters.NewRow();
         nrow[0] = par.name;
         nrow[1] = par.associated;
         nrow[2] = par.id;
         TCatParameters.Rows.Add(nrow);
     }
     DGV_SetConstraints(ref DGV_catParameters, new DataGridViewRow[] { DGV_catParameters.Rows[0], DGV_catParameters.Rows[1], DGV_catParameters.Rows[2]}, new DataGridViewColumn[] { DGV_catParameters.Columns["Название"] });
     DGV_SetMask(ref DGV_catParameters);
 }

        protected virtual IEnumerable<IPackage> FilterPackages(IPackageRepository sourceRepository, IQueryable<IPackage> packages)
        {
            if (CollapseVersions)
            {
                // In the event the client is going up against a v1 feed, do not try to fetch pre release packages since this flag does not exist.
                if (IncludePrerelease && sourceRepository.SupportsPrereleasePackages)
                {
                    // Review: We should change this to show both the absolute latest and the latest versions but that requires changes to our collapsing behavior.
                    packages = packages.Where(p => p.IsAbsoluteLatestVersion);
                }
                else
                {
                    packages = packages.Where(p => p.IsLatestVersion);
                }
            }

            if (UseRemoteSourceOnly && _firstValueSpecified)
            {
                // Optimization: If First parameter is specified, we'll wrap the IQueryable in a BufferedEnumerable to prevent consuming the entire result set.
                packages = packages.AsBufferedEnumerable(First * 3).AsQueryable();
            }

            IEnumerable<IPackage> packagesToDisplay = packages.AsEnumerable()
                                                              .Where(PackageExtensions.IsListed);

            // When querying a remote source, collapse versions unless AllVersions is specified.
            // We need to do this as the last step of the Queryable as the filtering occurs on the client.
            if (CollapseVersions)
            {
                // Review: We should perform the Listed check over OData for better perf
                packagesToDisplay = packagesToDisplay.AsCollapsed();
            }

            if (ListAvailable && !IncludePrerelease)
            {
                // If we aren't collapsing versions, and the pre-release flag is not set, only display release versions when displaying from a remote source.
                // We don't need to filter packages when showing installed packages.
                packagesToDisplay = packagesToDisplay.Where(p => p.IsReleaseVersion());
            }

            packagesToDisplay = packagesToDisplay.Skip(Skip);

            if (_firstValueSpecified)
            {
                packagesToDisplay = packagesToDisplay.Take(First);
            }

            return packagesToDisplay;
        }

 /// <summary>
 /// Simply calculates the total price from a given list of carts.
 /// </summary>
 public static decimal CalculateGrandTotal(IQueryable<Cart> carts)
 {
     return carts.AsEnumerable().Sum(c => c.UnitPrice * c.Count);
 }