public void UpdateOrderWithoutRetrieving(Order order)
{
using (var context = new EFRecipesEntities())
{
context.Orders.Attach(order);
if (order.Status == "Received")
{
var entry = context.ObjectStateManager.GetObjectStateEntry(order);
entry.SetModifiedProperty("Quantity");
context.SaveChanges();
}
}
}
public void UpdateOrderByRetrieving(Order order)
{
using (var context = new EFRecipesEntities())
{
var dbOrder = context.Orders.Single(o => o.OrderId == order.OrderId);
if (dbOrder != null &&
StructuralComparisons.StructuralEqualityComparer.Equals(order.TimeStamp, dbOrder.TimeStamp))
{
dbOrder.Quantity = order.Quantity;
context.SaveChanges();
}
}
}
public void UpdateOrderByRetrieving(Order order)
{
using (var context = new EFRecipesEntities())
{
// fetch current entity from database
var dbOrder = context.Orders.Single(o => o.OrderId == order.OrderId);
if (dbOrder != null &&
// execute concurrency check
StructuralComparisons.StructuralEqualityComparer.Equals(order.TimeStamp, dbOrder.TimeStamp))
{
dbOrder.Quantity = order.Quantity;
context.SaveChanges();
}
}
}
public Order InsertOrder()
{
using (var context = new EFRecipesEntities())
{
// remove previous test data
context.ExecuteStoreCommand("delete from chapter9.[order]");
var order = new Order {
Product = "Camping Tent", Quantity = 3, Status = "Received"
};
context.Orders.AddObject(order);
context.SaveChanges();
return(order);
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
context.Agents.AddObject(new Agent {
Name = "Phillip Marlowe", Phone = "202 555-1212"
});
context.Agents.AddObject(new Agent {
Name = "Janet Rooney", Phone = "913 876-5309"
});
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
// change the phone numbers
var agent1 = context.Agents.Where(a => a.Name == "Janet Rooney").Single();
var agent2 = context.Agents.Where(a => a.Name == "Phillip Marlowe").Single();
agent1.Phone = "817 353-4458";
context.SaveChanges();
// update the other agent's number out-of-band
context.ExecuteStoreCommand(@"update Chapter14.agent set Phone = '817 294-6059' where name = 'Phillip Marlowe'");
// now change it using the model
agent2.Phone = "817 906-2212";
try
{
context.SaveChanges();
}
catch (OptimisticConcurrencyException ex)
{
Console.WriteLine("Exception caught updating phone number: {0}", ex.Message);
}
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine("-- All Agents --");
foreach (var agent in context.Agents)
{
Console.WriteLine("Agent: {0}, Phone: {1}", agent.Name, agent.Phone);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
public void UpdateOrderWithoutRetrieving(Order order)
{
using (var context = new EFRecipesEntities())
{
try
{
context.Orders.Attach(order);
if (order.Status == "Received")
{
context.Entry(order).Property(x => x.Quantity).IsModified = true;
context.SaveChanges();
}
}
catch (OptimisticConcurrencyException ex)
{
// Handle OptimisticConcurrencyException
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter4.Member");
context.Members.AddObject(new Member {
Name = "Robert Dewey", Email = "*****@*****.**"
});
context.Members.AddObject(new Member {
Name = "Nancy Steward", Email = "*****@*****.**"
});
context.Members.AddObject(new Member {
Name = "Robin Rosen", Email = "*****@*****.**"
});
context.SaveChanges();
}
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var car1 = new Vehicle {
Manufacturer = "Toyota", Model = "Camry", Year = 2010
};
var car2 = new Vehicle {
Manufacturer = "Chevrolet", Model = "Corvette", Year = 2010
};
var r1 = new Rental {
Vehicle = car1, RentalDate = DateTime.Parse("2/2/2010"), Payment = 59.95M
};
var r2 = new Rental {
Vehicle = car2, RentalDate = DateTime.Parse("2/2/2010"), Payment = 139.95M
};
context.AddToRentals(r1);
context.AddToRentals(r2);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
string reportDate = "2/2/2010";
var totalRentals = new ObjectParameter("TotalRentals", typeof(int));
var totalPayments = new ObjectParameter("TotalPayments", typeof(decimal));
var vehicles = context.GetVehiclesWithRentals(DateTime.Parse(reportDate), totalRentals, totalPayments);
Console.WriteLine("Rental Activity for {0}", reportDate);
Console.WriteLine("Vehicles Rented");
foreach (var vehicle in vehicles)
{
Console.WriteLine("{0} {1} {2}", vehicle.Year.ToString(), vehicle.Manufacturer, vehicle.Model);
}
Console.WriteLine("Total Rentals: {0}", ((int)totalRentals.Value).ToString());
Console.WriteLine("Total Payments: {0}", ((decimal)totalPayments.Value).ToString("C"));
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var poet = new Poet {
FirstName = "John", LastName = "Milton"
};
var poem = new Poem {
Title = "Paradise Lost"
};
var meter = new Meter {
MeterName = "Iambic Pentameter"
};
poem.Meter = meter;
poem.Poet = poet;
context.Poems.AddObject(poem);
poem = new Poem {
Title = "Paradise Regained"
};
poem.Meter = meter;
poem.Poet = poet;
context.Poems.AddObject(poem);
poet = new Poet {
FirstName = "Lewis", LastName = "Carroll"
};
poem = new Poem {
Title = "The Hunting of the Shark"
};
meter = new Meter {
MeterName = "Anapestic Tetrameter"
};
poem.Meter = meter;
poem.Poet = poet;
context.Poems.AddObject(poem);
poet = new Poet {
FirstName = "Lord", LastName = "Byron"
};
poem = new Poem {
Title = "Don Juan"
};
poem.Meter = meter;
poem.Poet = poet;
context.Poems.AddObject(poem);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
context.ContextOptions.LazyLoadingEnabled = true;
var poets = from p in context.Poets select p;
foreach (var poet in poets)
{
Console.WriteLine("{0} {1}", poet.FirstName, poet.LastName);
foreach (var poem in poet.Poems)
{
Console.WriteLine("\t{0} ({1})", poem.Title, poem.Meter.MeterName);
}
}
}
// using our vwLibrary view
using (var context = new EFRecipesEntities())
{
var items = from i in context.vwLibraries select i;
foreach (var item in items)
{
Console.WriteLine("{0} {1}", item.FirstName, item.LastName);
Console.WriteLine("\t{0} ({1})", item.Title, item.MeterName);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
private static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var web = new CustomerType {
Description = "Web Customer", CustomerTypeId = 1
};
var retail = new CustomerType {
Description = "Retail Customer", CustomerTypeId = 2
};
var customer = new Customer {
Name = "Joan Smith", CustomerType = web
};
customer.CustomerEmails.Add(new CustomerEmail {
Email = "*****@*****.**"
});
customer.CustomerEmails.Add(new CustomerEmail {
Email = "*****@*****.**"
});
context.Customers.Add(customer);
customer = new Customer {
Name = "Bill Meyers", CustomerType = retail
};
customer.CustomerEmails.Add(new CustomerEmail {
Email = "*****@*****.**"
});
context.Customers.Add(customer);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
// Include() method with a string-based query path to the
// corresponding navigation properties
var customers = context.Customers
.Include("CustomerType")
.Include("CustomerEmails");
Console.WriteLine("Customers");
Console.WriteLine("=========");
foreach (var customer in customers)
{
Console.WriteLine("{0} is a {1}, email address(es)", customer.Name,
customer.CustomerType.Description);
foreach (var email in customer.CustomerEmails)
{
Console.WriteLine("\t{0}", email.Email);
}
}
}
using (var context = new EFRecipesEntities())
{
// Include() method with a strongly-typed query path to the
// corresponding navigation properties
var customerTypes = context.CustomerTypes
.Include(x => x.Customers
.Select(y => y.CustomerEmails));
Console.WriteLine("\nCustomers by Type");
Console.WriteLine("=================");
foreach (var customerType in customerTypes)
{
Console.WriteLine("Customer type: {0}", customerType.Description);
foreach (var customer in customerType.Customers)
{
Console.WriteLine("{0}", customer.Name);
foreach (var email in customer.CustomerEmails)
{
Console.WriteLine("\t{0}", email.Email);
}
}
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
DateTime d1 = DateTime.Parse("8/8/2009");
DateTime d2 = DateTime.Parse("8/12/2008");
var c1 = new Customer {
Name = "Jill Robinson", City = "Dallas"
};
var c2 = new Customer {
Name = "Jerry Jones", City = "Denver"
};
var c3 = new Customer {
Name = "Janis Brady", City = "Dallas"
};
var c4 = new Customer {
Name = "Steve Foster", City = "Dallas"
};
context.Invoices.AddObject(new Invoice {
Amount = 302.99M, Description = "New Tires", Date = d1, Customer = c1
});
context.Invoices.AddObject(new Invoice {
Amount = 430.39M, Description = "Brakes and Shocks", Date = d1, Customer = c2
});
context.Invoices.AddObject(new Invoice {
Amount = 102.28M, Description = "Wheel Alignment", Date = d1, Customer = c3
});
context.Invoices.AddObject(new Invoice {
Amount = 629.82M, Description = "A/C Repair", Date = d2, Customer = c4
});
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine("Using eSql query...");
string sql = @"Select value i from
EFRecipesModel.GetInvoices(EFRecipesEntities.Invoices) as i
where i.Date > DATETIME'2009-05-1 00:00'
and i.Customer.City = @City";
var invoices = context.CreateQuery <Invoice>(sql, new ObjectParameter("City", "Dallas")).Include("Customer");
foreach (var invoice in invoices)
{
Console.WriteLine("Customer: {0}\tInvoice for: {1}, Amount: {2}", invoice.Customer.Name, invoice.Description, invoice.Amount);
}
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine();
Console.WriteLine("Using LINQ query...");
DateTime date = DateTime.Parse("5/1/2009");
var invoices = from invoice in
MyFunctions.GetInvoices(context.Invoices)
where invoice.Date > date
where invoice.Customer.City == "Dallas"
select invoice;
foreach (var invoice in ((ObjectQuery <Invoice>)invoices).Include("Customer"))
{
Console.WriteLine("Customer: {0}, Invoice for: {1}, Amount: {2}", invoice.Customer.Name, invoice.Description, invoice.Amount);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var course = new Course {
Title = "Biology 101"
};
var fred = new Instructor {
Name = "Fred Jones"
};
var julia = new Instructor {
Name = "Julia Canfield"
};
var section1 = new Section {
Course = course, Instructor = fred
};
var section2 = new Section {
Course = course, Instructor = julia
};
var jim = new Student {
Name = "Jim Roberts"
};
jim.Sections.Add(section1);
var jerry = new Student {
Name = "Jerry Jones"
};
jerry.Sections.Add(section2);
var susan = new Student {
Name = "Susan O'Reilly"
};
susan.Sections.Add(section1);
var cathy = new Student {
Name = "Cathy Ryan"
};
cathy.Sections.Add(section2);
context.Courses.AddObject(course);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
var graph = context.Courses.Include("Sections.Instructor").Include("Sections.Students");
Console.WriteLine("Courses");
Console.WriteLine("=======");
foreach (var course in graph)
{
Console.WriteLine("{0}", course.Title);
foreach (var section in course.Sections)
{
Console.WriteLine("\tSection: {0}, Instrutor: {1}", section.SectionId.ToString(), section.Instructor.Name);
Console.WriteLine("\tStudents:");
foreach (var student in section.Students)
{
Console.WriteLine("\t\t{0}", student.Name);
}
Console.WriteLine("\n");
}
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
