Entity Framework and Windows Presentation Foundation Walk Through

Entity Framework

The first thing to do is get the Database Model going:

  1. Fire up Visual Studio 2012
  2. Create a new project called EF_WPF_Example, Select Windows, WPF project type.
  3. If the Data Sources side bar (windows) is not visible Press Shift+Alt+D
  4. Click Add New Data Sources and in the wizard...
    1. Click Database, Next
    2. Entity Data Model, Next
    3. Generate from database, Next
    4. Click New Connection...
    5. Give your server name and click on the drop down under "Select or enter a database name"
    6. Select the University Database Example that we have been working on.
    7. Test the connection to make sure that it works, then click OK
    8. Make a special note of the connection string name, Click next

    9. Under tables place check marks next to "advisor", "instructor", "student" and notice the Model Namespace (Mine was UniversityExampleModel), Click Finish.

Your file should now look like this:

EFModel.png

One last thing: Rename the file to be UniversityModel (I just don't like Model1.edmx).

WPF Part

Now we will build the GUI (You could do this in Blend too, but I'm going to use Visual Studio 2012).

  1. Make sure the toolbox is visible.

  2. Add two Label and two TextBox objects on the screen and one DataGrid so that it looks like the following: