Installing AdventureWorks Sample Databases from Microsoft

1. Type in the following URL into your browser's address bar

     http://msftdbprodsamples.codeplex.com/

2.  Click on the "Download" button on page

3.  Click on the recommended download link

4.  Unizp the file you just downloaded

5.  Open the SQL Server Management Studio, then right click on "Databases" and then select "Restore Database"

6.  Select "Device" under "Source"

7.  Click on the "..." button, and the "Select" backup devices will appear, select "File" for "Backup media type"

8.  Click on the "Add" button, and select the "AdventureWorks2014.bak" file, then click "OK"

8.  Click "OK" on the "Select backup devices" screen

9.  Click "OK" on "Restore Database" window

10.  A message will pop up that says you have successfully restored the AdventureWorks2014 database

11.  The "AdventureWorks2014" database is now added to your SQL Server instance

Installing AdventureWorks Sample Databases from Microsoft

1. Type in the following URL into your browser's address bar
     http://msftdbprodsamples.codeplex.com/

2.  Click on the "Download" button on page

3.  Click on the recommended download link

4.  Unizp the file you just downloaded

5.  Open the SQL Server Management Studio, then right click on "Databases" and then select "Restore Database"

6.  Select "Device" under "Source"

7.  Click on the "..." button, and the "Select" backup devices will appear, select "File" for "Backup media type"

8.  Click on the "Add" button, and select the "AdventureWorks2014.bak" file, then click "OK"

8.  Click "OK" on the "Select backup devices" screen

9.  Click "OK" on "Restore Database" window

10.  A message will pop up that says you have successfully restored the AdventureWorks2014 database

11.  The "AdventureWorks2014" database is now added to your SQL Server instance

Entity Framework Part 1: Installing Entity Framework 6.1.1 With NuGet

In this blog I will show how to install Entity Framework 6.1.1 with NuGet in Visual Studio 2013

1.  Create a project call "Northwind"

2.  Right click on the solution that the project resides in, then select "Manage NuGet Packages for Solution...."

3.  The "Manage NuGet Packages" window is displayed

4.  In left hand side select "Online", and then select "nuget.org"

5.  In the "Search Online" textbox type in the word "EntityFramework", this will search for the latest version of EntityFramework available

6.  Click on the "Install" button

7.  Select the project you want install EntityFramework to be installed in, then click on "OK"

8. Click "OK" to accept the terms and conditions

9.  When the Entity Framework is installed you will see a check mark next to package

10.  Now you will see the the project has references to the Entity Framework DLLs

Blogs in the Entity Framework Series:

1. Installing Entity Framework 6.1.1 With NuGet
2. Creating Entity Model From an Existing Database Entity Framework 6.1.1
3. Using the Entity Framework Objects In ASP.NET Project
4. Entity Framework (Database First) Part 4: Using the LINQ and Projection To SELECT Columns From Entities

Entity Framework Part 1: Installing Entity Framework 6.1.1 With NuGet

In this blog I will show how to install Entity Framework 6.1.1 with NuGet in Visual Studio 2013

1.  Create a project call "Northwind"

2.  Right click on the solution that the project resides in, then select "Manage NuGet Packages for Solution...."

3.  The "Manage NuGet Packages" window is displayed

4.  In left hand side select "Online", and then select "nuget.org"

5.  In the "Search Online" textbox type in the word "EntityFramework", this will search for the latest version of EntityFramework available

6.  Click on the "Install" button

7.  Select the project you want install EntityFramework to be installed in, then click on "OK"

8. Click "OK" to accept the terms and conditions

9.  When the Entity Framework is installed you will see a check mark next to package

10.  Now you will see the the project has references to the Entity Framework DLLs

Blogs in the Entity Framework Series:

1. Installing Entity Framework 6.1.1 With NuGet
2. Creating Entity Model From an Existing Database Entity Framework 6.1.1
3. Using the Entity Framework Objects In ASP.NET Project
4. Entity Framework (Database First) Part 4: Using the LINQ and Projection To SELECT Columns From Entities

Real World Example: The Intranet Application

I am starting a new series in this blog that creates a real world example.  Most web application requires the same things over and over again, and in every organization I worked in there is an intranet application either home grown, or some flavor of a COTS product.  So you can't get anymore real world than that.  I will use the rapid development method, so some background information will not be discussed.  Feel free to do research at the concepts that you don't understand.