Adding a New Field to the Movie Model and Tablehttp://asp.netThu, 06 Jun 2013 20:18:02 GMTumbracoComments for Adding a New Field to the Movie Model and TableenComment Posted by juliandormonhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableTue, 21 Aug 2012 16:12:47 GMT00000000-0000-0000-0000000016240After deleting the DB and the pasting your code into the Package Manager Controls I get the following error:

PM> Enable-Migrations -ContextTypeName MvcMovie.Models.MovieDBContext

The project 'MvcMovie' failed to build.

]]>Comment Posted by rmlysikhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableMon, 27 Aug 2012 13:37:45 GMT00000000-0000-0000-0000000016300In addition to deleting the Movies.mdf file as stated in the beginning of this section, I also needed to drop the database before I could successfully execute the statement "update-database" from the Package manager Console. I had been getting the error Cannot attach the file '...\Movies.mdf' as database 'Movies'.

]]>Comment Posted by bnazeemhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableMon, 27 Aug 2012 19:39:45 GMT00000000-0000-0000-0000000016312follow-up to my last comment to this error:

PM> Enable-Migrations -ContextTypeName MvcMovie.Models.MovieDBContext

Enable-Migrations : A parameter cannot be found that matches parameter name 'ContextTypeName'.

At line:1 char:35

+ Enable-Migrations -ContextTypeName <<<< MvcMovie.Models.MovieDBContext

+ CategoryInfo : InvalidArgument: (:) [Enable-Migrations], ParameterBindingException

+ FullyQualifiedErrorId : Named

I did update to the latest EntityFramework through "Manage Nuget P and it works.

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableMon, 27 Aug 2012 20:52:55 GMT00000000-0000-0000-0000000016315@juliandormon --The project 'MvcMovie' failed to build.

Fix the build (compile problems). I updated the instructions.

@rmlysik -- , I also needed to drop the database before

Thanks, I updated the instructions to include dropping the DB first.

@bnazeem - Enable-Migrations : A parameter cannot be found that matches parameter name 'ContextTypeName'.

Thanks for posting the problem/solution.

]]>Comment Posted by virshuhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableSun, 09 Sep 2012 22:29:40 GMT00000000-0000-0000-0000000016403Thank you for covering new features of Entity Framework. Looking forward to MVC 4 tutorial as well that would be useful to MVC developers interested to learn new MVC 4 features.

]]>Comment Posted by ZAiNThttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableSun, 18 Nov 2012 17:55:14 GMT00000000-0000-0000-0000000016824Rick: Why are you using Enable-Migrations -ContextTypeName MvcMovie.Models.MovieDBContext? Why not simply use Enable-Migrations? In the past before reading this article the only thing you needed to do was Enable-Migrations. The ContextTypeName made me confused.

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableTue, 20 Nov 2012 13:35:25 GMT00000000-0000-0000-0000000016837@ZAiNT : -ContextTypeName

Membership db now has a context class too, so there are two when you create one and you have to specify the context class in the enable-migrations command. Previously they didn’t have a context class for the membership db so you didn't need to specify which context class to apply migrations.

]]>Comment Posted by thronedoggiehttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableMon, 03 Dec 2012 10:30:23 GMT00000000-0000-0000-0000000016921Rick - Love the tutorial.

Can't help but wonder why, in the above example after adding Rio Bravo II, all of the other movies show up as "R"?

(And I can't believe that WHMS is rated "G". Didn't Meg do her impression of a faked orgasm in the restaurant? : )

]]>Comment Posted by DeveloperPRhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableWed, 05 Dec 2012 19:43:31 GMT00000000-0000-0000-0000000016945Hi,

I really want to know how to use this approach:

"Explicitly modify the schema of the existing database so that it matches the model classes. The advantage of this approach is that you keep your data. You can make this change either manually or by creating a database change script."

Thanks for the help.

]]>Comment Posted by thecoleortonhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableTue, 11 Dec 2012 14:04:29 GMT00000000-0000-0000-0000000016985Hi Rick,

So, the first step in this tutorial is to delete the existing database. What if you're wanting to run a migration on an existing database - with existing data?

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableWed, 16 Jan 2013 21:25:36 GMT00000000-0000-0000-0000000018189@thecoleorton What if you're wanting to run a migration on an existing database - with existing data?

The tutorial goes on to explain the migration approach with existing data.

]]>Comment Posted by RiaanPieterse81http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableTue, 05 Feb 2013 13:30:12 GMT00000000-0000-0000-0000000018347You also need to update the Delete View, it won't give any errors, if you don't the Ratings won't display on "http://localhost:XXXX/Movies/Delete/X" page.

]]>Comment Posted by salman_sulaiman_1979http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableFri, 08 Feb 2013 00:33:09 GMT00000000-0000-0000-0000000018380Thanks Rick! Great stuff once again!

Just a quick note I would like to share, I might be missing something but perhaps it is a typo,not sure.. Rick, in the code snippet where you were specifiying the Migration process and modifying the "Seed" method, in the first code snippet there is this line of code: "context.Movies.AddOrUpdate( i => i.Title,...", which didn't make sense to me because the AddOrUpdate in this case is expecting parameters of type "Movie", the next code snippet (the one below it immediately worked out fine with me without any trouble. I just thought I would pin point this, perhaps I am missing something, not sure.

right! just liked to share this really quick, i am continuing with the rest of the tutorial, simply beautiful! Thanks once again Rick! and good luck folks! really cool comments down here. fantastic!

Best Wishes,

~Salman~

]]>Comment Posted by shamimbd0http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableTue, 12 Feb 2013 01:18:07 GMT00000000-0000-0000-0000000018409Have I need to delete Database every time after adding new Property in class to migrate database?

]]>Comment Posted by abdelkaderhttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableThu, 21 Feb 2013 12:42:46 GMT00000000-0000-0000-0000000018485@shamimbd0 : No, you don't need to drop the database each time you add a new field to your model. Just type these two commands in the PM to update the db with the model :

add-migration WhatEverYouWant

update-database

]]>Comment Posted by Danny117http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableWed, 06 Mar 2013 13:28:59 GMT00000000-0000-0000-0000000018590I made it this far. Code first migrations argh!

]]>Comment Posted by payinihttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableMon, 11 Mar 2013 16:17:29 GMT00000000-0000-0000-0000000018650Great tutorials. Thank you.

]]>Comment Posted by render22http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableThu, 28 Mar 2013 11:37:29 GMT00000000-0000-0000-0000000018796First of all, thanks for the tutorial.

This is probably a very dumb question (I'm really new to this), but in the Configuration.cs file example, how are we using i? What is this parameter saying? (I understand it's lambda expression etc, but I don't understand what it's purpose is here as I don't see i being used anywhere else).

context.Movies.AddOrUpdate( i => i.Title,

]]>Comment Posted by roixd21http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableWed, 03 Apr 2013 05:43:51 GMT00000000-0000-0000-0000000018839just as I suspected, now Im using 2012 express web instead of vs2010ultimate, no initial catalog error thrown.. I'm continuing using this express edition :)

]]>Comment Posted by CYPThttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableSun, 05 May 2013 13:28:34 GMT00000000-0000-0000-0000000019040Great Tutorial, Thank you!

]]>Comment Posted by NikolaBorichttp://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableThu, 16 May 2013 05:52:10 GMT00000000-0000-0000-0000000019116If you have the error Cannot attach the file '...\Movies.mdf' as database 'Movies'

Open the "Developer Command Propmpt for VS2012" under your Start/Programs menu.

The run the following commands:

sqllocaldb.exe stop v11.0

sqllocaldb.exe delete v11.0

Thanks for this tutorial !

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-new-field-to-the-movie-model-and-tableThu, 06 Jun 2013 20:18:02 GMT00000000-0000-0000-0000000019262@salman_sulaiman_1979 - and @render22

code: "context.Movies.AddOrUpdate( i => i.Title,.

-- I'll be updating www.asp.net/ soon where I'll explain that in detail.

]]>