1-) C# - Entityde komutlar istediğimiz alanları alma isteğe göre listeleme çıkarma yapan döngü komut

  // dataGridView1.DataSource = db.Tbl_Urun.ToList();  //ENTİTY İLE TABLOYU LİSTELEME

            dataGridView1.DataSource = (from x in db.Tbl_Urun  //datagiridwievi isteğe göre sıralama

                                        select new

                                        {

                                            x.URUNID,

                                            x.URUNAD,

                                            x.MARKA,

                                            x.STOK,

                                            x.FİYAT,

                                            x.Tbl_Kategori.AD,

                                            x.DURUM

                                        }).ToList();