Querying a view

Querying a view is the same as querying a table. For example you can query the view "current product lists" like this:

static void TestView()
{
   NorthwindEntities 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);
   }
    NWEntities.Dispose();
}

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