Downloads

Tuesday, January 01 2008

This page will be used to provide code samples from the book and the sample databases. I am also placing downloads for my Entity Framework conference presentations on this page.

1st Edition Downloads__________________________________

(Looking for downloads for 2nd Edition?)

Note: A few people have reported problems with the links because of the url redirection. If you can't get the downloads from the main links, try the "alternate" which I am now providing along with each link.

Database Scripts for Programming Entity Framework  (202kb)   [alternate]
*updated 1/31/2009 (minor change to data in BreakAway)
*updated 2/25/2009 to add vOfficeAddresses view back into BreakAway. It is not used in code samples, but is used to help explain DefiningQuery in Chapter 13.
*updates 3/27/2009 to modify a problem that might cause the vOfficeAddresses view to not get created.

  1. ReadMe.txt
  2. Create_ProgrammingEFDB1_SQLServer2005.sql (Script to create sample database used in Chapters 1-6 for SQL Server 2005 )
  3. Create_ProgrammingEFDB1_SQLServer2008.sql (Script to create sample database used in Chapters 1-6 for SQL Server 2008 )
  4. Create_BreakAway_SQLServer2005.sql (Script to create sample database used in Chapters 7+  for SQL Server 2005 )
  5. Create_BreakAway_SQLServer2008.sql (Script to create sample database used in Chapters 7+ for SQL Server 2008 )

A note for SQL Server Express Users  Mar 10, 2009   [alternate]
 

Chapter 7 BreakAway Model Projects (57kb)  Jan 28, 2009   [alternate]
*Updated 9/7/2009 with modified ReadMe.TXT
Contains VB and CSharp projects for the BreakAway model created in the Chapter 7 walkthroughs.

Chapter 8 WinForm and WPF Projects (964kb)  Jan 28, 2009    [alternate]
*updated 1/31/2009: minor change to WinForm UI to overcome known issue with ComboBoxes (not related to EF)
*updated Mar 10, 2009: minor change to ValidateNewTrips method in WPF solution
*Updated 9/7/2009 with modified ReadMe.TXT
Contains solutions for the WinForm and WPF applications created in Chapter 8. There are VB and CSharp versions for each solution. Each solution also contains a project containing the version of the BreakAway model that is current for this chapter.

Chapter 11 EntityDataSource Projects (646kb)  Jan 28, 2009    [alternate]
*Updated 9/7/2009 with modified ReadMe.TXT
Contains solutions for the second ASP.NET application created in Chapter 11. There is one solution in VB and one in CSharp. Each solution also contains a project containing the version of the BreakAway model that is current for this chapter. The "HelloEntities" example created in the beginning of the chapter is not included.

Chapter 14 Web Service and WCF Service Projects (1.75mb)  Jan 28, 2009    [alternate]
*Updated 9/7/2009 with modified ReadMe.TXT
Contains solutions for the Web Service and WCF applications created in Chapter 14. Each application is provided in VB and CSharp and each solution also contains a project containing the version of the BreakAway model that is current for this chapter.

Chapter 16 Generated Views Samples (34kb) Jan 28, 2009    [alternate]
Contains a VB and CSharp version of the pre-generated views for the BreakAway model created using EDMGen /FullGeneration.

Chapter 17 ObjectStateEntry Visualizer (89kb) Jan 29, 2009   [alternate]
Contains both a VB and a CSharp project with the ObjectStateEntry Visualizer Extension Method built in Chapter 17.

Chapter 17 Dynamic Entity Graph Builder (153kb) Jan 29, 2009    [alternate]
Contains both a VB and a CSharp project with the dynamic entity graph code which is the last sample in Chapter 17.

Chapter 17 (and other) Extension Methods
Contains CSharp extension methods used throughout the book. Many of these are contained in their relevant project downloads as well.

Chapter 18 - Persisted State Entry
VB Version

Chapter 19 - Scripts for AdventureWorksSuperLT (108kb) April 9, 2009 [alternate]
Two separate scripts to create this database in SS2005 and SS2008.

Chapter 20 n-Tier Windows Form Solution (1.14mb) Jan 31, 2009  [alternate]
*updated Feb 24th to work around an EF problem that impacted the invoked queries
*updated July 8th to incorporate some code that didn't make it from my working samples to the download samples.
*Updated 9/7/2009 with modified ReadMe.TXT
Contains both a VB and a CSharp solutions for WinForm app and DataBridge built in Chapter 20.

Chapter 21 n-Tier ASP.NET Solution (711kb) Feb 24 2009    [alternate]
*Updated 9/7/2009 with modified ReadMe.TXT
Contains both a VB and a CSharp solutions for the ObjectDataSource ASP.NET app built in Chapter 21.

Chapter 22 WCF  Solution (711kb) Feb 27 2009    [alternate]
*Updated 9/7/2009 with modified ReadMe.TXT
 

2nd Edition Downloads___________________________________________

Please note that I will begin uploading the code samples for the 2nd edition after the book is out in print. Until then, I'm very busy editing based on the feedback from tech reviewers, rough cuts readers and editors so that we can getting the book done, so I do not want to stop the presses to get the  code samples ready and available for the rough cut. Some of the downloads from the first edition are pretty close to 2nd edition, so feel free to take a look at those.

Rough Cuts Edition:
Sample Database for Chapters 2-6
BreakAway Database for 2nd Edition (exe installer)

Chapter 16
SaveCustomerMessage.xml
Example of the message sent from client to service in the Self-Tracking Entites sectino of the chapter.  

EF Conference Presentation Downloads_______________________________

November 2009 Presentations:

1. DevConnections Fall 2009 Entity Framework Tips & Tricks
    Powerpoint
     http://www.slideshare.net/JulieLerman/lerman-vvs14-ef-tips-and-tricks

2. DevConnections Fall 2009 Entity Framework 4 and ASP.NET

    Powerpoint
    http://www.slideshare.net/JulieLerman/lerman-adx303-entity-framework-4-in-aspnet

3. DevConnections Fall 2009 Entity Framework 4 and WCF
    PowerPoint
    http://www.slideshare.net/JulieLerman/lerman-vvs13-entity-framework-4-and-wcf

4. OreDev, Vermont.NET and NotATPDC: Agile Entity Framework 4

  • Part 1: POCOs
  • Part 2: Repository/Testing (demos coming soon)

    Powerpoint
    http://www.slideshare.net/JulieLerman/agileentity-framework-4

---------------------------------------------------------------

Entity Framework Deep Dive into Object Services
SDN 2008, DevReach 2008, DevConnections Fall 2008, DevTeach Montreal 2008
Contains PDF version of PowerPoint and zip files with samples

EF Workshop Database Script (updated June 12, 2009)

Entity Framework Tips & Tricks (updated August 31, 2009)
Presented at Communities2Communities (Warsaw Poland), TechEd 2009 North America, O'ReillyNet Webcast
Contains demos, PowerPoint & database script files

Other Downloads_______________________________

AdventureWorksSuperLT SQL Server 2008 database
Simplified version of Microsoft's AdventureWorksLT sample database
This is an executable created with RedGate's SQL Packager. If you prefer scripts, look under 1st Edition, Chapter 19 higher up on this page.