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();
}