Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2013-02-15 00:24:01 →
Size: 983
Editor: 24-151-197-61
Comment:
← Revision 2 as of 2013-02-15 00:46:18 → ⇥
Size: 1469
Editor: 24-151-197-61
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Entity Framework and Windows Presentation Foundation Walk Through = Entity Framework and Windows Presentation Foundation Walk Through =

== Entity Framework ==

The first thing to do is get the Database Model going:
Line 16: Line 20:
  1. Rename the file to be UniversityModel.
Line 18: Line 21:
Your file should now look like this:
Line 19: Line 23:
[[attachment:EFModel.jpg]]

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.
  1. Add two Label and two TextBox objects on the screen and one DataGrid so that it looks like the following:

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.jpg

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:

DatabaseManagementSystems/EntityFrameworkWpfExample (last edited 2013-02-15 18:58:39 by embsys-tekscope-2)