WCF Multi-layer Services Development with Entity Framework Fourth Edition

Querying a view

Querying a view is the same as querying a table (the view needs to have a unique key). For example, you can query the view "current product lists" as follows:

static void TestView()
{
   using(var NWEntities = new NorthwindEntities())
  {
   var currentProducts = from p 
                      in NWEntities.Current_Product_Lists
                      select p;
   foreach (var p in currentProducts)
    {
        Console.WriteLine("Product ID: {0} Product Name: {1}", 
             p.ProductID, p.ProductName);
    }
  }
}

This will get and print all of the current products using the view.