static void RunExample() { using (var context = new EFRecipesEntities()) { context.Employees.AddObject(new Employee { FirstName = "Jill", LastName = "Robins", Birthdate = DateTime.Parse("3/2/1976") }); context.Employees.AddObject(new Employee { FirstName = "Michael", LastName = "Kirk", Birthdate = DateTime.Parse("4/12/1985") }); context.Employees.AddObject(new Employee { FirstName = "Karen", LastName = "Stanford", Birthdate = DateTime.Parse("6/18/1963") }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Query using eSql"); var esql = @"Select EFRecipesModel.FullName(e) as Name, EFRecipesModel.Age(e) as Age from EFRecipesEntities.Employees as e"; var emps = context.CreateQuery <DbDataRecord>(esql); foreach (var emp in emps) { Console.WriteLine("Employee: {0}, Age: {1}", emp["Name"], emp["Age"]); } } using (var context = new EFRecipesEntities()) { Console.WriteLine("\nQuery using LINQ"); var emps = from e in context.Employees select new { Name = MyFunctions.FullName(e), Age = MyFunctions.Age(e) }; foreach (var emp in emps) { Console.WriteLine("Employee: {0}, Age: {1}", emp.Name, emp.Age.ToString()); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var cus1 = new Customer { Name = "Robert Stevens", Email = "*****@*****.**" }; var cus2 = new Customer { Name = "Julia Kerns", Email = "*****@*****.**" }; var cus3 = new Customer { Name = "Nancy Whitrock", Email = "*****@*****.**" }; context.Customers.AddObject(cus1); context.Customers.AddObject(cus2); context.Customers.AddObject(cus3); context.SaveChanges(); } // using object services using (var context = new EFRecipesEntities()) { Console.WriteLine("Customers..."); string esql = "select value c from Customers as c"; var customers = context.CreateQuery <Customer>(esql); foreach (var customer in customers) { Console.WriteLine("{0}'s email is: {1}", customer.Name, customer.Email); } } Console.WriteLine(); // using EntityClient using (var conn = new EntityConnection("name=EFRecipesEntities")) { Console.WriteLine("Customers..."); var cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = "select value c from EFRecipesEntities.Customers as c"; using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess)) { while (reader.Read()) { Console.WriteLine("{0}'s email is: {1}", reader.GetString(1), reader.GetString(2)); } } } Console.WriteLine(); // using object services without the VALUE keyword using (var context = new EFRecipesEntities()) { Console.WriteLine("Customers..."); string esql = "select c.Name, c.Email from Customers as c"; var records = context.CreateQuery <DbDataRecord>(esql); foreach (var record in records) { var name = record[0] as string; var email = record[1] as string; Console.WriteLine("{0}'s email is: {1}", name, email); } } Console.WriteLine(); // using EntityClient without the VALUE keyword using (var conn = new EntityConnection("name=EFRecipesEntities")) { Console.WriteLine("Customers..."); var cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = "select c.Name, C.Email from EFRecipesEntities.Customers as c"; using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess)) { while (reader.Read()) { Console.WriteLine("{0}'s email is: {1}", reader.GetString(0), reader.GetString(1)); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }