Accessing Your Model's Data from a Controllerhttp://www.asp.netMon, 11 Feb 2013 07:07:03 GMTumbracoComments for Accessing Your Model's Data from a ControllerenComment Posted by jclementshttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerThu, 08 Mar 2012 20:53:54 GMT00000000-0000-0000-0000000015069Hi Rick,

I'm working through your Intro to ASP.NET MVC4 tutorial and I'm beginning the section "Accessing Your Model's Data from a Controller". I've attempted to add the MoviesController but the combo boxes for Model Class and Data context class do not list the Movie selections that you have specified. They only show "ChangePasswordModel", "LoginModel", and "RegisterModel"

Jeff

]]>Comment Posted by DaveCenkerhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerWed, 21 Mar 2012 14:04:37 GMT00000000-0000-0000-0000000015176Why is "model" (lowercase m) used when referencing a single object in the edit and detail views, but "Model" (capital m) is used when referencing a list of objects in the index view? Is this purely a convention to differentiate between single and multiple objects, or is there some other reason?

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerThu, 26 Jul 2012 21:04:06 GMT00000000-0000-0000-0000000016055>>Why is "model" (lowercase m) used when referencing

Model is required in the Index method because it's a propery on the ViewDataDictionary. model => model.Title in @Html.DisplayFor is by convention. You could write @Html.DisplayFor(foo => foo.Title)

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerTue, 31 Jul 2012 11:00:39 GMT00000000-0000-0000-0000000016077@thanksinadvance - on the purpose of the Dispose override, see "Ensuring that Database Connections Are Not Left Open" in this tutorial: www.asp.net/

]]>Comment Posted by stifler_08http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 20 Aug 2012 08:47:40 GMT00000000-0000-0000-0000000016220I am using visual studio 2010. When i am adding the movies controller i am getting an error which i think is in the connection string. The error is

"Unable to retrieve metadata for 'MvcMovie.Models.Movie. Invalid value for key 'attachdbfilename'.

I am new to mvc development and im not sure how to tackle this error.

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 20 Aug 2012 20:48:33 GMT00000000-0000-0000-0000000016229@stifler_08 --Unable to retrieve metadata -- You probably need to install the SQL Server Data Tools as explained above.

]]>Comment Posted by fincher42http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerThu, 23 Aug 2012 12:30:29 GMT00000000-0000-0000-0000000016265Hi Rick,

Thanks for a well-written, wonderful introduction to MVC4.

On page www.asp.net/

I think there's a typo:

You mention "movies.sdf" when I think you meant "movies.mdf".

Thanks again for a great article!

]]>Comment Posted by rico33126http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerThu, 23 Aug 2012 16:30:36 GMT00000000-0000-0000-0000000016268Hi there

I am working on the the mvcMovie tutorial by Rick Anderson.

I have reached the Accessing the Model's Data from a controller but the Movies.mdf in the App_Data folder does not get created, thus this portion of the tutorial does run properly.

In the Moviescontroller.cs, in the //Get Movies/ Section and in lines:

public ActionResult Index()

{

return View(db.Movies.ToList());

I get an "InvalidOperation Exception was unhandled by user code" The supplied SqlConnection does not specify an initial catalog..

I have the entity framework installed, have SQL server installed and so forth.

Using the SQL Toolbar in Visual Studio, I have the ability to connect to the local SQL: server but do not see the Movies.mdf

Is there anything that I am missing?

Has anyone completed this part of the tutorial?

Could someone give me an idea of what I may want to change/add.

Rio

]]>Comment Posted by rmlysikhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerFri, 24 Aug 2012 14:55:44 GMT00000000-0000-0000-0000000016277@rico33126 I ran into the same issue as well. I came across a blog posting www.pradyblog.com/ that suggested setting the "Initial Catalog" parameter in the connection string to "Movies" as shown below. This also worked for me.

<add name="MovieDBContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Movies.mdf;Initial Catalog=Movies;Integrated Security=True" providerName="System.Data.SqlClient"/>

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 27 Aug 2012 19:08:11 GMT00000000-0000-0000-0000000016308@fincher42 sdf typo -- Thanks, Fixed.

@rico33126 InvalidOperation Exception was unhandled by user code" The supplied SqlConnection does not specify an initial catalog.

-- You need to install LocalDB and SSDT per the instructions

@rmlysik "Initial Catalog" parameter

-- This tutorial uses LocalDB, not SQL Express. You can follow the blog if you'd like to use SQL Express, but the LocalDB instructions for Visual Studio 2010 work.

]]>Comment Posted by pepsibothttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 27 Aug 2012 20:56:01 GMT00000000-0000-0000-0000000016316Thanks Ricco. Something else I noticed that isn't something anyone would do, but is still frustrating, is if you shut down the server, delete the mdf and ldf files in App_Data/ and then try to build and run the site again. It will fail on trying recreate the DBs a 2nd time (for me). I wonder how I am getting that to happen...

]]>Comment Posted by H Maryleshttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 24 Sep 2012 18:08:56 GMT00000000-0000-0000-0000000016505I'm using VS 2010, and I'm reading all over the internet that LocalDB is not intended to work with with VS2010 (although it will work for a DB File attach, which is what you're doing here -- but I don't see a point in installing pieces of software which have limited or no use for me beyond this tutorial). Thus, I used .\SQLEXPRESS, and I let the scaffolding process create my data context class (same as I did in MVC 3), and everything works the same as what you represent with LocalDB.

]]>Comment Posted by dchang92606http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerFri, 28 Sep 2012 22:20:21 GMT00000000-0000-0000-0000000016545Rick,

Awesome tutorial. I have a quick question about the data model. Specifically, how does the Entity Framework know that ID is the primary key? I don't think it's specified anywhere in the class (or is the first attribute considered the primary key). What if I wanted to create a multi-column primary key?

DC

]]>Comment Posted by pcortes09http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerWed, 21 Nov 2012 11:16:53 GMT00000000-0000-0000-0000000016846Well explained...

]]>Comment Posted by garfieldzfhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerSun, 25 Nov 2012 20:37:25 GMT00000000-0000-0000-0000000016872if I want to define Title to varchar(20) type in the database, how I can to change in the Movie.cs. now it's nvarchar(max)

Add a attribute?

]]>Comment Posted by trung nguyenhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerFri, 28 Dec 2012 15:17:41 GMT00000000-0000-0000-0000000017078Great article. Question, can Entity Framework Code First works on SQL Azure? In other words, can I run this example again but instead of using the LocalDB, how can I pass in the AzureDB Server and have EF Code First create a DB for this example?

]]>Comment Posted by chebaflohttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerFri, 11 Jan 2013 14:18:58 GMT00000000-0000-0000-0000000018160I'm new in MVC4. I'm programming with VB VS2010 I'm not use C#, so I'm trying to translate this tutorial to VB. I have a problem when I try to add the Controller, I have this error message:

There was an error generating MVCMovies.Models.MovieDBContext. Try rebuilding your project.

My source code model is like this:

Imports System

Imports System.Data.Entity

Namespace Models

Public Class Movie

Public Property Id As Integer

Public Property Title As String

Public Property RealeaseDate As DateTime

Public Property Genre As String

Public Property price As Decimal

End Class

Public Class MovieDBContext

Inherits DbContext

Public Movies As DbSet(Of Movie)

End Class

End Namespace

What is wrong? What can I do? Thanks in advance

]]>Comment Posted by chebaflohttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerFri, 11 Jan 2013 14:24:35 GMT00000000-0000-0000-0000000018161I found my mistake....

Public Movies As DbSet(Of Movie)

must be

Public Property Movies As DbSet(Of Movie)

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerWed, 16 Jan 2013 21:21:23 GMT00000000-0000-0000-0000000018188@trung nguyen can Entity Framework Code First works on SQL Azure?

Yes. You need to use a connection string to SQL Azure.

@dchang92606 ID --> PK. That's the default. You can use attributes to change the PK.

]]>Comment Posted by tihanyilhttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 21 Jan 2013 14:45:24 GMT00000000-0000-0000-0000000018221Hi, that blog helped me too with the 'InvalidOperation Exception' problem

www.pradyblog.com/

]]>Comment Posted by ricardosampaiohttp://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerSat, 26 Jan 2013 15:08:12 GMT00000000-0000-0000-0000000018257IF I introduce values like 9.99 the result is 999.00 (detail: I'm calling from Brazil,. Here we use values like R$ 9,99).

How can I configure the application in order to work with values like R$ 9,99. Thanks.

]]>Comment Posted by tihi1234http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 04 Feb 2013 07:48:02 GMT00000000-0000-0000-0000000018337Hello, and thanks for a great guide!

When im trying to access the "/Movies" i get a {"CREATE DATABASE permission denied in database 'master'."}. I have gone done the tutorial twice and still get the databaseproblem, any idea?

]]>Comment Posted by tihi1234http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerWed, 06 Feb 2013 03:14:19 GMT00000000-0000-0000-0000000018352Nm, solved it!

]]>Comment Posted by salman_sulaiman_1979http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerThu, 07 Feb 2013 13:44:07 GMT00000000-0000-0000-0000000018372Thanks Rick!

this is really cool, the paradime of code first, new way of thinking.

I really didn't know (of course being a newbie), that i could work on my application and test it with data (localdb) all within visual studio (so far I have been working out the tutorials with VS2012 express, so far so good)

Best wishes & Good luck to everyone!

~Salman~

]]>Comment Posted by shamimbd0http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controllerMon, 11 Feb 2013 07:07:03 GMT00000000-0000-0000-0000000018406Really amazing that how create database Entity Framework code first.

]]>