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

EN ÇOK STOKLU URUNUN ADI

1- labelControl49.Text = db.TBLURUN.OrderByDescending(x => x.STOK).Select(y => y.AD).First();

2- labelControl49.Text = (from x in db.TBLURUN

                                 orderby x.STOK descending

                          select x.AD).FirstOrDefault(); // Yada First()

EN YUKSEK FIYATLI URUN ADI

1- labelControl.Text = db.TBLURUN.OrderByDescending(x => x.SATISFIYAT).Select(y => y.AD).First();

2- labelControl49.Text = (from x in db.TBLURUN

                                 orderby x.SATISFIYAT descending

                          select x.AD).First(); // Yada FirstOrDefault()

BEYAZ EŞYA (ID = 4) KATEGORİSİNDEKİ TOPLAM STOK SAYISI

1- labelControl.Text = db.TBLURUN.Where(y => y.KATEGORI == 4).Sum(z => z.STOK).ToString();

2- labelControl49.Text = (from x in db.TBLURUN

                                 where x.KATEGORI == 4

                                 select new

                                 {

                                     Stok = x.STOK

                          }).Sum(x=>x.Stok).ToString();

BEYAZ EŞYA  (ID = 4) KATEGORİSİNDEKİ TOPLAM URUN SAYISI

1- labelControl.Text = db.TBLURUN.Count(x => x.KATEGORI == 4).ToString();

2- labelControl49.Text = (from x in db.TBLURUN

     select new

    {

Kategori=x.KATEGORI == 4

    }).Count(y=>y.Kategori).ToString();

3- labelControl49.Text = (from x in db.TBLURUN

                                 where x.KATEGORI == 4

                          select x.AD).Count().ToString();

BEYAZ EŞYA (ID = 4) KATEGORİSİNDEKİ FARKLI ADLA KAYITLI URUN SAYISI

1- labelControl49.Text = (from x in db.TBLURUN

                          where x.KATEGORI == 4

     select x.AD).Distinct().Count().ToString();

2- labelControl.Text =

db.TBLURUN.Where(x => x.KATEGORI == 4).Select(y => y.AD).Distinct().Count().ToString();

TOPLAM MARKA SAYISI

1- labelControl49.Text = (from x in db.TBLURUN

                          select x.MARKA).Distinct().Count().ToString();

2- labelControl.Text = db.TBLURUN.Select(x=>x.MARKA).Distinct().Count().ToString();