Adding a New Field to the Movie Model and Database Tablehttp://asp.netWed, 08 May 2013 15:37:56 GMTumbracoComments for Adding a New Field to the Movie Model and Database TableenComment Posted by rsmachadohttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldThu, 12 May 2011 10:10:02 GMT00000000-0000-0000-0000000013142Hi,

I’m trying to follow this tutorial, but the script for the “MovieInitializer”.

There is an error with the script in the tutorial, because it doesn’t work at all.

Please, should be possible to publish a fix?

Thanks in advance,

Ricardo

example: instead "using", should be "imports"?

In my sample, there is 24 errors: declaratio expected, syntax, end of statment expected, etc.!

]]>Comment Posted by Justin Aurandhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldThu, 26 May 2011 10:42:48 GMT00000000-0000-0000-0000000013279The MovieInitializer is in C# rather than VB. This is also the case with a cope snippet on the prior page of this tutorial.

]]>Comment Posted by asim.mhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldFri, 27 May 2011 15:48:55 GMT00000000-0000-0000-0000000013294Imports System

Imports System.Collections.Generic

Imports System.Data.Entity

Namespace MvcMovie.Models

Public Class MovieInitializer

Inherits DropCreateDatabaseIfModelChanges(Of MovieDBContext)

Protected Overrides Sub Seed(ByVal context As MovieDBContext)

Dim movies = New List(Of Movie) From {

New Movie With {.Title = "When Harry Met Sally", .ReleaseDate = Date.Parse("1989-1-11"), .Genre = "Romantic Comedy", .Rating = "R", .Price = 7.99D},

New Movie With {.Title = "Ghostbusters ", .ReleaseDate = Date.Parse("1984-3-13"), .Genre = "Comedy", .Rating = "R", .Price = 8.99D},

New Movie With {.Title = "Ghostbusters 2", .ReleaseDate = Date.Parse("1986-2-23"), .Genre = "Comedy", .Rating = "R", .Price = 9.99D},

New Movie With {.Title = "Rio Bravo", .ReleaseDate = Date.Parse("1959-4-15"), .Genre = "Western", .Rating = "R", .Price = 3.99D}}

movies.ForEach(Function(d) context.Movies.Add(d))

End Sub

End Class

End Namespace

]]>Comment Posted by wankwonghohttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldWed, 15 Jun 2011 11:38:15 GMT00000000-0000-0000-0000000013516Thank you for the coding of VB version. =)

]]>Comment Posted by cesar.sacconehttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldTue, 21 Jun 2011 16:30:29 GMT00000000-0000-0000-0000000013577asim.m, you are the man. thanks a lot, I was seriously considering looking for another tutorial.

]]>Comment Posted by boocoderhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldTue, 12 Jul 2011 11:08:16 GMT00000000-0000-0000-0000000013748For situations in which I don't want to use database initialization and favour the second option...how do I have to change the database schema? I tried right-clicking the movies table en change schema (adding a column) but I keep getting an out of sync error. I removed the EdmMetadata table, it now works but seems kind of radical to me having now syncing table anymore ;).

]]>Comment Posted by Machellohttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldWed, 27 Jul 2011 01:10:38 GMT00000000-0000-0000-0000000013857I would also like to know how to pursue the second method of updating the database schema manually and then generating a new ModelHash to plug into the EdmMetadata ModelHash column.

If you want use the first method yet preserve the data, I would think that you could somehow back it up to a temporary table, then run the database initialization code and instead of using the seed values, somehow repopulate with the data from the second table, using default values for any added columns.

]]>Comment Posted by DanR_Qchttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/vb/adding-a-new-fieldWed, 08 May 2013 15:37:56 GMT00000000-0000-0000-0000000019072I also had the out of sync error when using the second method, after having updated the db schema by adding the rating column. To avoid this, disable the db initializer by putting this call in the context class' constructor (my example is in vb):

Entity.Database.SetInitializer(Of MovieDBContext)(Nothing)

HTH

]]>