Entity Framework snippets

entityframeworksnippets.cs

using (MyEntities context = new MyEntities())
{
    // Query a collection
    IQueryable<MyThing> thingsQuery = from thing in context.Things
                                      where thing.Name == "Foo"
                                      select product;
    foreach (var t in thingsQuery)
    {
        DoSomethingWith(t);
    }

    // Delete an object
    context.DeleteObject(thingsQuery.First());

    // Query for a single object, and process related objects
    var thing = context.Things.Include("Subthings").Where(o => o.ThingID.Equals("foo")).FirstOrDefault();
    if (thing != null)
    {
        foreach (var subthing in thing.Subthings)
            DoSomethingWithSubthing(subthing);
    }

    // Save changes
    try
    {
        int count = context.SaveChanges();
    }
    catch (OptimisticConcurrencyException)
    {
        context.Refresh(RefreshMode.ClientWins, things);
        context.SaveChanges();
    }
    catch (UpdateException)
    {
        // ...
    }
    catch (InvalidOperationException)
    {
        // ...
    }
}