Machine, C# - rextester

Language: Layout:

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class MachineData
    {
        public DateTime Date { get; set; }

public string PartNumber { get; set; }

public int MoldNum { get; set; }

public int MachineNum { get; set; }

public decimal MU { get; set; }
    }
    
    public class Program
    {
        // Simulate call to database
        public static IQueryable<MachineData> LoadSamples()
        {
            return new List<MachineData>()
            {
                new MachineData() {
                    Date = new DateTime(2016, 12, 2),
                    PartNumber = "1185-5B8",
                    MoldNum = 6580,
                    MachineNum = 12,
                    MU = 0.428M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 2),
                    PartNumber = "2249300",
                    MoldNum = 7797,
                    MachineNum = 36,
                    MU = 0.271M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 2),
                    PartNumber = "146865",
                    MoldNum = 5096789,
                    MachineNum = 12,
                    MU = 0.260M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 16),
                    PartNumber = "123456",
                    MoldNum = 7787,
                    MachineNum = 56,
                    MU = 0.354M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 16),
                    PartNumber = "123456",
                    MoldNum = 787,
                    MachineNum = 54,
                    MU = 0.450M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 16),
                    PartNumber = "123456",
                    MoldNum = 777,
                    MachineNum = 56,
                    MU = 0.799M
                },
                new MachineData() {
                    Date = new DateTime(2016, 12, 16),
                    PartNumber = "123456",
                    MoldNum = 87,
                    MachineNum = 54,
                    MU = 0.611M
                }
            }
            .AsQueryable();
        }
        
        public static void Main(string[] args)
        {
            var dbItems = LoadSamples();

var query =
                dbItems
                    .GroupBy(x => new { x.Date, x.MachineNum })
                    .Select(x => new
                    {
                        Date = x.Key.Date,
                        MachineNum = x.Key.MachineNum,
                        AverageMU = x.Average(i => i.MU * 100)
                    })
                    .ToList(); // This query does what you want

//  Just to print (ignore this)
            foreach (var item in query.GroupBy(x => x.Date))
            {
                Console.WriteLine("Date: " + item.Key.Date.ToShortDateString());

foreach (var machine in item)
                {
                    Console.WriteLine("Machine: " + machine.MachineNum + " - " + machine.AverageMU + "%");
                }

Console.Write("\r\n\r\n");
            }
        }
    }
}

Show compiler warnings [ + ] Show input
Compilation time: 0,16 sec, absolute running time: 0,27 sec, cpu time: 0,25 sec, average memory usage: 19 Mb, average nr of threads: 5