EF - Include With Where Clause | C# Online Compiler

EF - Include With Where Clause by Anonymous

// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Extensions

using System;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
					
public class Program
{
	public static void Main()
	{
		 var transactions = new List<ShopTransactionEntity>()
            {
                new ShopTransactionEntity(){ 
					ItemId = 1,
					Price = 10,
					CurrencyId = 1
				},
			    new ShopTransactionEntity(){ 
					ItemId = 1,
					Price = 10,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 1,
					Price = 10,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 1,
					Price = 10,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 100,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 100,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 200,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 200,
					CurrencyId = 1
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 20,
					CurrencyId = 2
				},
			 	new ShopTransactionEntity(){ 
					ItemId = 2,
					Price = 20,
					CurrencyId = 2
				},
            };
		var query = transactions.GroupBy(t => new { t.Price, t.ItemId, t.CurrencyId }, t => t, (key, g) => new {key.ItemId, key.Price, key.CurrencyId, Quantity = g.Count()});
		foreach (var transaction in query){
			Console.WriteLine("ItemId: {0}, Price {1}, CurrencyId {2}, Quantity {3}", transaction.ItemId, transaction.Price, transaction.CurrencyId, transaction.Quantity);
		}
	}
	
	public class ShopTransactionEntity
    {
        public int ItemId { get; set; }
        public int Price { get; set; }
        public int CurrencyId { get; set; }
    }
 }

​x
 
// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Extensions
​
using System;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
                    
public class Program
{
    public static void Main()
    {
         var transactions = new List<ShopTransactionEntity>()
            {
                new ShopTransactionEntity(){ 
                    ItemId = 1,
                    Price = 10,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 1,
                    Price = 10,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 1,
                    Price = 10,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 1,
                    Price = 10,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 100,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 100,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 200,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 200,
                    CurrencyId = 1
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 20,
                    CurrencyId = 2
                },
                new ShopTransactionEntity(){ 
                    ItemId = 2,
                    Price = 20,
                    CurrencyId = 2
                },
            };
        var query = transactions.GroupBy(t => new { t.Price, t.ItemId, t.CurrencyId }, t => t, (key, g) => new {key.ItemId, key.Price, key.CurrencyId, Quantity = g.Count()});
        foreach (var transaction in query){
            Console.WriteLine("ItemId: {0}, Price {1}, CurrencyId {2}, Quantity {3}", transaction.ItemId, transaction.Price, transaction.CurrencyId, transaction.Quantity);
        }
    }
    
    public class ShopTransactionEntity
    {
        public int ItemId { get; set; }
        public int Price { get; set; }
        public int CurrencyId { get; set; }
    }
 }

------------
Batch no: 1
------------
1 : USD 1.2701
2 : JPY 138.97
3 : BGN 1.9558
4 : CZK 27.54
5 : DKK 7.4432
------------
Batch no: 2
------------
1 : GBP 0.7827
2 : HUF 312.18
3 : LTL 3.4528
4 : PLN 4.1827
5 : RON 4.4125
------------
Batch no: 3
------------
1 : SEK 9.2018
2 : CHF 1.2071

Cached Result
Last Run:	8:13:19 am
Compile:	0.173s
Execute:	0.016s
Memory:	8kb
CPU:	0.016s

View IL Code