protected void Page_Load(object sender, EventArgs e) { NorthwindEntities db = new NorthwindEntities(); IEnumerable <Customers_By_City_Result> results = from c in db.Customers_By_City("London") select c; GridView1.DataSource = results; GridView1.DataBind(); }
static void Listing20_15() { Console.WriteLine("{0} : Begin", new StackTrace(0, true).GetFrame(0).GetMethod().Name); // create the ObjectContext NorthwindEntities context = new NorthwindEntities(); IEnumerable <Customers_By_City_Result> custs = context.Customers_By_City("London"); foreach (Customers_By_City_Result cust in custs) { Console.WriteLine("{0}, {1}", cust.CompanyName, cust.ContactName); } Console.WriteLine("{0} : End", new StackTrace(0, true).GetFrame(0).GetMethod().Name); }
static void Main(string[] args) { // create a context NorthwindEntities context = new NorthwindEntities(); // query the stored procedure IEnumerable <Customers_By_City_Result> results = from e in context.Customers_By_City("London") where !e.ContactName.Contains("Hardy") select e; foreach (Customers_By_City_Result item in results) { Console.WriteLine("Name: {0}", item.CompanyName); } // wait for input before exiting Console.WriteLine("Press enter to finish"); Console.ReadLine(); }