Querying a view

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

static void TestView()
{
   using(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);
    }
  }
}

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset