Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums What is Aggregate Function in LINQ? – MindStick
Ask Question

1 Answers

Ravi Vishwakarma
Ravi Vishwakarma 24 Sep 2021
Report Abuse

An Aggregate function takes more than two arguments and works on the requirement. there are many aggregate functions in LINQ

SOME function of LINQ

  1. SUM()    return the sum of a collection
  2. MIN()    return the minimum of collection
  3. MAX()     returns the maximum collection
  4. COUNT()    return the length of the collection
  5. Average()    return is the average of a collection
  6. Aggregate()   returns the value as needed from a collection

Example

using System;
using System.Linq;
using System.Collections.Generic;

class MyProgram
{ 
 static void Main(string[ ] args)
    { 

  int[] intAry = {45,78,5,896,4,5,8,65,99,66,55,88,5,558,56,55,45,23};
  var Sum = intAry.Where(x => x%2 == 0).Sum();
  Console.WriteLine('Sum of array : ' + Sum);

  var Min = intAry.Min();
  Console.WriteLine('Min of array : ' + Min);

  var Max = intAry.Max();
  Console.WriteLine('Max of array : ' + Max);

  var Count = intAry.Count();
  Console.WriteLine('Length of array : ' + Count);

  var Avg = intAry.Average();
  Console.WriteLine('Average of array : ' + Avg);

  var Aggregate = intAry.Aggregate((a,b) => a+b);
  Console.WriteLine('Aggregate function of array : ' + Aggregate);

    } 
}

Output

Sum of array : 1754

Min of array : 4

Max of array : 896

Length of array : 18

Average of array : 119.77777777777777

Aggregate function of array : 2156
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md