Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Objects;
using EntityFrameworkLibrary;


namespace EntityFrameworkConsole
{

    class Program
    {
        
        static void Main1(string[] args)
        {

            SampleEntities entities = new SampleEntities();

            //Sample sample = new Sample();
            //sample.SampleName = "Örnek Adı";
            //sample.SampleValue = 2.7;
            //entities.Samples.AddObject(sample);
            //entities.SaveChanges();

            //Sample sample = entities.Samples.Single(s => s.SampleId== 1);
            //Console.WriteLine("Örnek Adı {0} Değeri {1}",sample.SampleName,sample.SampleValue);

            //Sample sample = entities.Samples.Single(s => s.SampleId== 1);
            //sample.SampleName = "Yeni Ad";
            //sample.SampleValue = 3.14;
            //entities.SaveChanges();    

            //Sample sample = entities.Samples.Single(s => s.SampleId== 1);
            //entities.Samples.DeleteObject(sample);
            //entities.SaveChanges();  


            //foreach (Sample sample in entities.Samples)
            //{
            //    Console.WriteLine("Örnek Adı {0} Değeri {1}", sample.SampleName, sample.SampleValue);
            //}


            //List<Sample> sampleList = entities.Samples.ToList();
            List<Sample> sampleList=entities.Samples.Where(s => s.SampleValue<4 ).ToList();
            foreach(Sample sample in sampleList){
                Console.WriteLine("Örnek Adı {0} Değeri {1}", sample.SampleName, sample.SampleValue);
            }
            //var query = from s in entities.Samples select s ;
            //var query = from s in entities.Samples  where s.SampleValue<4 select s ;
            //foreach (Sample sample in query.ToList())
            //{
            //    Console.WriteLine("Örnek Adı {0} Değeri {1}", sample.SampleName, sample.SampleValue);
            //}

        }
        static void Main(string[] args)
        {
            SampleEntities entities = new SampleEntities();
          
            //Category category = entities.Categories.Single(c => c.CategoryId== 2);
            //Console.WriteLine("Kategori No {0} Adı {1}", category.CategoryId, category.CategoryName);
            //foreach (Product product in category.Products) {

            //    Console.WriteLine("Ürün No {0} Adı {1} Fiyatı {2}", product.CategoryId, product.ProductName, product.SalesPrice);
            //}

            //Product product = entities.Products.Single(p => p.ProductId == 1);
            //Console.WriteLine("Ürün No {0} Adı {1} Fiyatı {2} Kategori {3}", 
            //    product.CategoryId, product.ProductName, product.SalesPrice,product.Category.CategoryName);

            //Category category =new Category();
            //category.CategoryName = "Kişisel Bakım";

            //Product product1 = new Product();
            //product1.ProductName = "Cilt Kremi";
            //product1.SalesPrice = 35;
            //category.Products.Add(product1);


            //Product product2 = new Product();
            //product2.ProductName = "Tırnak Makası";
            //product2.SalesPrice = 25;
            //category.Products.Add(product2);

            //entities.Categories.AddObject(category);

            //entities.SaveChanges();


           
            //List<Product> productList = entities.Products.Include("Category").Where(p => p.Category.CategoryId ==2).ToList();
            var query = from p in entities.Products where p.Category.CategoryId==2 select p;

            foreach (Product product in query.ToList())
            {
                Console.WriteLine("Ürün No {0} Adı {1} Fiyatı {2}", product.CategoryId, product.ProductName, product.SalesPrice);
            }
        }
    }
}