Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ExampleEntityLibrary;

namespace ExampleConsoleApplication
{
    class Program
    {
        static void Main(string[] args)
        {
            ExampleEntities db = new ExampleEntities();

            //Category category = db.Categories.Single(c => c.CategoryId == 2);
            //Console.WriteLine("Kategori " + category.CategoryName);

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

            //db.Categories.AddObject(category);
            //db.SaveChanges();
            //Console.WriteLine("Kategori " + category.CategoryId);



            //Category category = db.Categories.Single(c => c.CategoryId == 3);
            //category.CategoryName = "Değişik İsim";
            //db.SaveChanges();

            //Product product = db.Products.Single(p => p.ProductId == 1);
            //Console.WriteLine("Ürünün Kategorisi " + product.Category.CategoryName);

            Category category = db.Categories.Single(c => c.CategoryId == 1);
            //foreach (Product product in db.Products.Single(p => p.ProductId == 1).Category.Products)
            //foreach (Product product in category.Products) {

            //    Console.WriteLine("Ürün No {0} Adı {1} Fiyatı {2}", product.CategoryId, product.ProductName, product.SalesPrice);
            //}
            //List<Product> productList = db.Products.Where(p => p.Category.CategoryId == 2).ToList();
            //foreach (Product product in productList)
            //{
            //    Console.WriteLine("Ürün No {0} Adı {1} Fiyatı {2}", product.CategoryId, product.ProductName, product.SalesPrice);
            //}
            var query = from p in db.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);
            }
            Console.ReadLine();

        }

    }
}