1-) C# - LINQ - En Az 2 Farklı Sorgu İle Veriye Erişme 2

HANGİ KATEGORİDE KAÇ ÜRÜN VAR(TABLO)

1-

 var deger = db.TBLURUN.SelectMany(a => db.TBLKATEGORI.Where(b => b.ID == a.KATEGORI), (b, a) =>

         new

            {   

            Kategori = a.AD,

                Toplam = a.TBLURUN.Count()

            ).Distinct();

         gridControl1.DataSource = deger.ToList();

2-

var degerler3 = (from x in db.TBLURUN

                          join y in db.TBLKATEGORI

                          on x.KATEGORI equals y.ID

                          select new

                          {

                              Kategori = y.AD,

                              Toplam = y.TBLURUN.Count()

                          }).Distinct();

         gridControl1.DataSource = degerler3.ToList();

HANGİ MARKANIN KAÇ ÜRÜNÜ VAR(TABLO)

1-

 var deger = db.TBLURUN.OrderBy(x => x.MARKA).GroupBy(y => y.MARKA).Select(z =>

  new

            {

                Marka = z.Key,

                Urun = z.Count()

            }).OrderByDescending(z=>z.Urun);

        gridControl1.DataSource = deger.ToList();

2-

 var deger = (from x in db.TBLURUN

                          orderby x.MARKA ascending

                          group x.MARKA by x.MARKA into x

                          select new

                          {

                              Marka = x.Key,

                              Toplam = x.Count()

                          });

         gridControl1.DataSource = deger.ToList();