Prerequisites

Microsoft Visual Studio 2012 or 2013

Trackable Entities is compatible with the following versions of Visual Studio.

  • Visual Studio 2012 Professional (or higher)
  • Visual Studio 2013 Professional (or higher)

Entity Framework 6.x Tools for Visual Studio 2012 or 2013

As of v2.1, Trackable Entities supports Entity Framework 6.x Tools for Visual Studio, which allow you to select individual tables either to generate Code First context and model classes, or to create an Entity Data Model, backed by an EDMX file, which represents entities and associations which make up a conceptual view of your database.

  • You can also download the EF 6.x Tools for Visual Studio here.
  • Add an “ADO.NET Entity Data Model” to your project.
  • Once the EDM wizard appears, select either “EF Designer from Database” or “Code First from Database.”
  • If you select the EF Designer option, you will see an Entity Data Model designer and use a Model First (also called Database First) approach.
    • Right-click on the EDM design surface and select “Add Code Generation Item.”
    • Under the Trackable, Data category, select “Service Trackable Entities EF 6.x Model First Generator,” and give it the same name as you gave the Entity Data Model.  Respond with “Yes” when prompted to overwrite the existing .tt files.
  • Because the ADO.NET Entity Data Model wizard is not compatible with Portable Class Libraries, you will need to add a separate .NET 4.5 Class Library project to the solution, copy over the CodeTemplates folder from the Client.Entities project, then add an Entity Data Model there.
    • Right-click the EDM design surface and select “Add Code Generation Item.” Then select “Client Trackable Entities EF 6.x Model First Generator.”

Entity Framework Power Tools

Optionally, you may wish to install the Entity Framework Power Tools.  If you have a relatively small number of tables, the EF Power Tools will reverse engineer Code First classes for all the tables in a database, creating a mapping class for each table.

  • From within Visual Studio, select Tools, Extensions and Updates, and search for “Entity Framework Power Tools”
  • You can also download the EF Power Tools here.

SQL Server Express and / or Full

Installing SQL Server Express will allow you to create the NorthwindSlim database, which is used by the Getting Started guide. Optionally, you can use full SQL Server (Developer or Standard), which provides SQL Profiler for viewing SQL generated by Entity Framework.

NorthwindSlim Database

For the purposes of illustration, the Samples and Getting Started guide both use the NorthwindSlim database, a trimmed down version of the Northwind sample database, which contains fewer tables and columns than the original version.

  • Download the SQL script here: http://bit.ly/northwindslim
  • Open SQL Management Studio for whatever version or edition of SQL Server you are using, then create a new database called NorthwindSlim.
  • Extract the contents of the zip file and run the NorthwindSlim.sql script in order to create the tables and insert data.

Last edited Aug 1, 2014 at 4:46 PM by tonysneed, version 4