Tuesday, May 29, 2012

Code First Migration Links

1. EF3 Code First Migration Walkthrough.            
 http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx

This post will provide an overview of the functionality that is available inside of Visual Studio for interacting with migrations. We will focus on the code-based workflow for using migrations. In this workflow each change is written out to a code-based migration that can reside in your project.  
Main commands:
 Add-Migration <MigrationName>
 Update-Database
Run from Package Manager Console. Tools->Library Package Manager->Package Manager Console

2. Best books for SQL database
http://stackoverflow.com/questions/2413805/best-books-for-sql-server-database-design