Errata

And there it is, DataAccess.BreakAwayContext with a Destinations table and a Lodgings table. That EdmMetadata table is used by Code First’s database initialization, and you’ll learn more about that later. "I do not have a "EdmMetaData" table when I run this project. (Example 2-3) I only have "dbo.Destinations" and "dbo.Lodgings" tables in my SQLEXPRESS database. How do I get that table?? If I will not need it later in the book I will not worry about it, but just very CURIOUS as to why I do not have that table. My project ran without any errors etc.. Many Thanks, Super Dave

Note from the Author or Editor:
This changed with EF 4.3 when they introduced migrations. This blog post that I wrote has more details about this change: http://thedatafarm.com/blog/data-access/using-ef-migrations-with-an-existing-database/

It says "At the end of this section, you’ll see how to configure composite keys." but I can't find any more information about composite keys.

Note from the Author or Editor:
For reader. yeah ..we totally blew that. Sorry. Check this EF team blog post and you'll see a composite key via data annotations if you look at the LadyInWaiting class. http://blogs.msdn.com/b/adonet/archive/2011/01/27/using-dbcontext-in-ef-feature-ctp5-part-1-introduction-and-model.aspx Here's the MSDN topic that has in it how to fluently configure composite keys. http://msdn.microsoft.com/en-us/library/hh295847(v=vs.103).aspx For O"Reilly - if we get more mentions of this, we'll consider adding in a little text. For now, just leave it be.

The process as described in the book up to page 7 work perfectly. If you run the Console project repeatedly the rows will keep being added to the database table. So far so good. However, in VS 2010 SP1, when I create a connection in Server Explorer to the SQLExpress file, the following problems occur: (the only work-around I found for this is to rename the context file but it has to be a name that was not previously used.) Obviously, I can't continue with this book unless I can also view the contents of the database. When the connection is open I get this error: at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)</StackTrace><ExceptionString>System.Data.EntityException: The underlying provider failed on Open. ---&gt; System.Data.SqlClient.SqlException: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\DataAccess.MyBreakAwayContext.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\DataAccess.MyBreakAwayContext_log.LDF". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". When the connection is close or deleted for VS 2010 Server Explorer, I get this error when I try to run the console project: {"An exception occurred while initializing the database. See the InnerException for details."} {"The underlying provider failed on Open."}

Note from the Author or Editor:
on page 29 there is a warning note at the top of the page. It currently has two paragraphs. Please add a 3rd paragraph that states : If you are using the Server Explorer in Visual Studio to look at the database, then you'll need to close the Server Explorer's connection to the database in order for Code First to drop and recreate the database. You can do this by right-clicking the database connection in Server Explorer and choosing "Close Connection".