Adding a Modelhttp://www.asp.netThu, 28 Feb 2013 04:32:21 GMTumbracoComments for Adding a ModelenComment Posted by juliandormonhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 20 Aug 2012 18:02:44 GMT00000000-0000-0000-0000000016227Actually I figured it out. I had pasted the argumnt class outside of the Mvc.Models namespace.

]]>Comment Posted by pepsibothttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 27 Aug 2012 20:42:36 GMT00000000-0000-0000-0000000016314In my situation the example given above for the connectionString does not work in Microsoft Visual Studio 2010 Pro.

The project will build but when I attempt to navigate to /Movies I am be greeted by an InvalidOperationException that reads "Unable to complete the operation. The supplied SqlConnection does not specify an initial Catalog."

The connectionString should equal "Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Movies.mdf;Initial Catalog=Movies;Integrated Security=True";

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelTue, 28 Aug 2012 14:44:52 GMT00000000-0000-0000-0000000016327@pepsibot connectionString does not work in Visual Studio 2010 Pro.

--You need to install LocalDB and SSDT as described in the tutorial.

]]>Comment Posted by peter kleinhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 30 Aug 2012 07:49:29 GMT00000000-0000-0000-0000000016348Hi Rick, Thanks for this excellent tutorial. I have been following you ever since 2010 with all variants of the tutorial. This week I installed VS 2010, which comes with .NET Framework 4.5. I do not succeed with the "using System.Data.Entity; ". I seems not to be there in 4.5

Is it advisable to simply move backwards to EF 4.0?

Best regards,

Peter Klein

]]>Comment Posted by peter kleinhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 30 Aug 2012 07:50:43 GMT00000000-0000-0000-0000000016349Sorry, slip of the keyboard: of course I mean: I have installed VC 2012!!

]]>Comment Posted by vijayan.kandasamyhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelFri, 02 Nov 2012 11:41:37 GMT00000000-0000-0000-0000000016733@Peter Klein - Change the connection string in MovieDBContext as below.

<add name="MovieDBContext"

connectionString="Data Source=(LocalDB)\v11.0; Initial Catalog=aspnet-MvcMovie-2012213181139; AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True"

providerName="System.Data.SqlClient"

/>

]]>Comment Posted by gmsteele44http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 08 Nov 2012 12:10:17 GMT00000000-0000-0000-0000000016764@nicka6 - I had both of those installed and still needed to specify an initial catalog. I think it's a 2010 thing :-(

]]>Comment Posted by garfieldzfhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelSun, 25 Nov 2012 19:55:39 GMT00000000-0000-0000-0000000016871This demo have no info about Pagination in MVC4.

]]>Comment Posted by selfayhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelFri, 14 Dec 2012 06:11:22 GMT00000000-0000-0000-0000000017008Very useful tutorial.

Thanks

]]>Comment Posted by selfayhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelFri, 14 Dec 2012 08:15:50 GMT00000000-0000-0000-0000000017010What about Movies.mdf file in the DataDirectory directory?

Next step will be impossible without these.

May be follow

Right click on the folder App_Data=>Add=>New Item=>SQL Server Database

solve the problem!?

]]>Comment Posted by yaqubonnethttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 17 Dec 2012 04:59:59 GMT00000000-0000-0000-0000000017021Hello Anderson,

I am confused here! where is the "Movies.mdf"?? i can find it nowhere?

Regards

]]>Comment Posted by yaqubonnethttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 17 Dec 2012 06:29:12 GMT00000000-0000-0000-0000000017023The Movies.mdf does not exists, what to do?

The Entity Framework will detect that the database connection string that was provided, pointed to a Movies database that didn’t exist yet, it will create the database automatically.

Please use this ConnectionString (Initial Catalog=Movies):

<add name="MovieDBContext"

connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Movies.mdf;Initial Catalog=Movies;Integrated Security=True"

providerName="System.Data.SqlClient"/>

Regards

]]>Comment Posted by navmedhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelWed, 09 Jan 2013 19:06:39 GMT00000000-0000-0000-00000000171481. There's already a default connection string. What is the need for another connection string?

2. Does every model need it's own connection string?

3. Does the name of the connection string need to match the name of the DBContext?

]]>Comment Posted by skillfulwebhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 10 Jan 2013 16:41:13 GMT00000000-0000-0000-0000000017154I accidentally added the connection string to the Web.config file in the ~/Views folder. The project seemed to be working, all the CRUD functioned as expected. However, no Movies.mdf file (or any *.mdf) was created in the project. Where was the data being stored?

When I corrected the error by moving the connection string to ~/Web.config and rebuilt the project, the Movies db was created but my earlier data vanished (which I expected it would.)

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelWed, 16 Jan 2013 21:17:29 GMT00000000-0000-0000-0000000018187@navmed Does every model need it's own connection string?

No - Does the name of the connection string need to match the name of the DBContext? Yes

@skillfulweb I accidentally added the connection string to the Web.config file in the ~/Views folder.

Probably in the default user directory.

]]>Comment Posted by unknownxhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelSun, 27 Jan 2013 17:03:41 GMT00000000-0000-0000-0000000018264Make sure you're exit debug mode before add the new class. I forgot to exit debug mode so my 'class' option was disable when attempt to add a new model class

]]>Comment Posted by salman_sulaiman_1979http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 07 Feb 2013 08:55:26 GMT00000000-0000-0000-0000000018368Hi there Rick and folks!

amazing tutorial rick!

Thanks mate!

I am following up the steps with my Vs2012 express edition on my laptop, so far so good.

Thanks once again and good luck folks.

~Salman~

]]>Comment Posted by salman_sulaiman_1979http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 07 Feb 2013 11:42:23 GMT00000000-0000-0000-0000000018370evening folks!

thanks for the tip there Selfay! :-)

I enjoy testing and playing around and diverting from the norm path (so to speak) just to see what would I get as a results!

once again, thank you Ricka6 for the tips! :)

what I did is (so far) is used a connectionString to a test db on my SqlExpress2012, and would like to see how far I would reach with that, of course all that locally on my own machine! just for the sake of it! :-)

I will have to continue with the next page and see if it works out! mmmm! that what I call fun!

Good luck folks & I will post my feedback and share it on here as I go along with you guys!

Best Wishes,

~Salman~

]]>Comment Posted by salman_sulaiman_1979http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 07 Feb 2013 12:35:38 GMT00000000-0000-0000-0000000018371Evening folks!

I would like to share how it went on, with me regarding the ConnectionString.

on the next tutorial page, Rick explains how the LocalDB under App_Data folder in our VS2012 Solution Explorer, how it gets created automatically on its own once you Debug (F5), and it really works. it created the DB in the App_Data and I can see the Tables (frankly, I am applying the tutorial on my own simple scenario, in my case I have a list of "Daily Journal Enteries" (instead of a list of movies), I find it much more fun and exciting when applying tutorials with a application (scope or scenario I could relate to or need..I don't know, that's just me!) ...

alright folks, I will carry on with the next tutorial (much more fun to come with Rick! amazing stuff, this is my first MVC experience). .

Good luck folks!

~Salman~

]]>Comment Posted by dnathanhoodhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelSun, 10 Feb 2013 09:40:51 GMT00000000-0000-0000-0000000018396I had a permissions issue while creating the database for this step. I wound up doing a major no-no and just giving "Everyone" write permissions on the directory. Does anyone know what account is actually being used in this step?

]]>Comment Posted by shamimbd0http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 11 Feb 2013 06:18:33 GMT00000000-0000-0000-0000000018403Entity Framework Code First is very nice.

]]>Comment Posted by HRaulhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelFri, 22 Feb 2013 13:27:32 GMT00000000-0000-0000-0000000018498For VS2010 problem in connectionString, just change to:

<add name="MovieDBContext"

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True"

providerName="System.Data.SqlClient"

/>

]]>Comment Posted by Stewy777http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 25 Feb 2013 05:10:11 GMT00000000-0000-0000-0000000018508Hi All,

Can anyone please help - I just went to rebuild the project after editing the web.config file and now I am getting an error which says

" Inconsistent accessibility: base class 'MvcMovie.Models.DbContext' is less accessible than class 'MvcMovie.Models.UsersContext' "

]]>Comment Posted by Danny117http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelMon, 25 Feb 2013 19:19:07 GMT00000000-0000-0000-0000000018515I'm with you so far. I built the project because one user in the coments did this and had a problem.

1>------ Build started: Project: MvcMovie, Configuration: Debug Any CPU ------

1> MvcMovie -> C:\Users\Dan\Documents\Visual Studio 2012\Projects\MvcMovie\MvcMovie\bin\MvcMovie.dll

========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

]]>Comment Posted by Stewy777http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/adding-a-modelThu, 28 Feb 2013 04:32:21 GMT00000000-0000-0000-0000000018541Problem now fixed not sure how !!!!

]]>