Accessing your Model's Data from a Controllerhttp://asp.netThu, 12 May 2011 14:22:53 GMTumbracoComments for Accessing your Model's Data from a ControllerenComment Posted by rema43001http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 14 Apr 2011 19:03:59 GMT00000000-0000-0000-0000000012810In Right-click the Controllers folder and create a new MoviesController controller. Don't appear the options:

•Controller name •Template •Model class •Data context class •Views

Only appear the options:

•Controller name and a checkbox (Add action methods for Create, Update, Delete, and Details scenarios)

Someone can help me?

]]>Comment Posted by xenomatichttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 14 Apr 2011 20:44:21 GMT00000000-0000-0000-0000000012812@rema43001 - They updated the tutorial after applying the MVC3 Tools Update. You will see the more elaborate Add Controller window after you apply the update to your system.

]]>Comment Posted by xenomatichttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 14 Apr 2011 20:47:57 GMT00000000-0000-0000-0000000012813BTW, you can get to the update here: www.microsoft.com/

]]>Comment Posted by rema43001http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 15 Apr 2011 19:34:37 GMT00000000-0000-0000-0000000012830Thank you xenomatic, now I can see the more elaborate Add Controller, but when I click Add I receive this error:

Could not load file or assembly 'file:///C:\Users\fiss\documents\visual studio 2010\Projects\MvcMovie\MvcMovie\bin\EntityFramework.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

Can you help me?

]]>Comment Posted by andre.vermeulenhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerSat, 16 Apr 2011 07:56:21 GMT00000000-0000-0000-0000000012835I am trying to use MVC3 with the Entity framework with Code First, but the code Template generation process in MS Visual Web Developer 2010 - is not detecting my Model in the models folder - giving a message - "No Model classes are available" - although I do have model classes for which I want to create controllers.

The templating option I've selected is "Controller with read/write actions and views using the Entity Framework".

I've uninstalled and reinstalled Web Developer 2010, but still having the same error.

Anyone know how I can get around this error?

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerSat, 16 Apr 2011 16:08:31 GMT00000000-0000-0000-0000000012839rema43001: The easiest thing is to create a new project. Alternatively, you can create a new dummy project and copy the EntityFramework.dll to your old project. The problem is you created your project before you installed the ASP.NET MVC 3 tools update.

andre.vermeulen: VWD "No Model classes are available".

Make sure you have VWD/SP1 installed. Create a new dummy internet project. In the home controller, right click About and add a strongly typed view. You should see three models ChangePasswordModel, LogOnModel and RegisterModel. Are your models public?

]]>Comment Posted by rema43001http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerMon, 18 Apr 2011 18:58:11 GMT00000000-0000-0000-0000000012858I create a new project and now all is fine, thanks ricka6!

]]>Comment Posted by saurabhjhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerWed, 20 Apr 2011 03:59:18 GMT00000000-0000-0000-0000000012878I was majorly stuck at this section: Accessing your Model's Data from a Controller

Kept getting an error that Visual Studio was unable to retrieve the Meta Data for the Movie.Model

What I ended up doing was using SQLExpress instead of SQL Server Compact as mentioned in the tutorial with the same database that Asp.Net uses to save the authentication.

Put this in your connection strings instead of what was mentioned in the previous step.

<add name="MovieDBContext"

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"

providerName="System.Data.SqlClient" />

Hope this helps someone stuck. (I think you need SP1 to use the Compact DB - not sure though)

]]>Comment Posted by M4rwhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerWed, 20 Apr 2011 04:38:46 GMT00000000-0000-0000-0000000012881Hi, I followed all the steps up till testing the create function. It works, but I can't enter '9.99' as price. It says 'The value '9.99' is not valid for Price.' But in Movie.cs I have like in the tutorial:

public decimal Price { get; set; }

I can however enter e.g. '10', then it's stored as '10,00'. When I edit the entry, change nothing and want to save, it says again that '10.00' is not a valid value, but when I save it as '10' it's back at '10.00' :O What's happening here?

]]>Comment Posted by M4rwhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerWed, 20 Apr 2011 05:18:46 GMT00000000-0000-0000-0000000012883Nevermind, it was my browser. The error occured in Firefox, but not in Opera :/

]]>Comment Posted by gorayahhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 21 Apr 2011 06:08:50 GMT00000000-0000-0000-0000000012911Hi

I am trying to create a controller based on information provider above and using existing database SQL Server 2005, but I everytime I m getting following error:

Unable to retrieve metadata for 'ApplicationName'. The provider did not return a ProviderManifestToken string.

Someone please help regarding this?

Cheers.

]]>Comment Posted by ashu_123http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 21 Apr 2011 10:03:31 GMT00000000-0000-0000-0000000012916Not able to see movies.sdf file, even after show all files and refresh.

Though all the things working fine.

I am not able to find movies.sdf file, by windows explorer(on my location) too.

]]>Comment Posted by joey doghttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 22 Apr 2011 10:48:37 GMT00000000-0000-0000-0000000012934I installed the Tools Update but when I click Add for MovieController I get this MVS warning: "Unable to retrieve metadata for 'MvcMovie.Models.Movie'. Unable to find the requested .Net Framework Data Provider. It may not be installed."

What else do I need and where do I get it?

]]>Comment Posted by happycamper01http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerMon, 25 Apr 2011 16:19:48 GMT00000000-0000-0000-0000000012964I experienced same issue as ashu 123. The app works fine, but I cannot find my Movies.sdf file anywhere. It's definitely not in the App_Data folder, and a search for the filename returns no results. Any ideas?

]]>Comment Posted by hulyapoyrazhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerTue, 26 Apr 2011 08:56:44 GMT00000000-0000-0000-0000000012980I created a project Visual Studio 2010 Ultimate and used SqL Server 2008 Express instead of Sql Server Compact.All the things works fine. Also Movies db created in Sql.

<add name="MovieDBContext"

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;database=Movies;User ID=sa;password=" providerName="System.Data.SqlClient"/>

]]>Comment Posted by eyalbhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerTue, 26 Apr 2011 11:28:39 GMT00000000-0000-0000-0000000012982i use sql server 2008 and get:

System.Data.SqlClient.SqlException: Invalid object name 'dbo.Movies'.

]]>Comment Posted by ricka6http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 29 Apr 2011 14:28:58 GMT00000000-0000-0000-0000000013030gorayah : eyalb : and other using SQL Server/SQL Express. Please use SQL Compact for this tutorial. Using SQL Express and SQL Server adds more complexity in dropping the DB. Once your DB gels so you won't be changing the schema it's easy to export the data to a full blown SQL Server. There is really no good reason to use SQL Express of SQL CE.

ashu_123 : happycamper01 : cannot find my Movies.sdf

make sure you connection string in the root web.config, not the one under views, which is easy to get by mistake. Also, use the exact connection string provided or the SDF will be in a system directory

]]>Comment Posted by clahttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerTue, 03 May 2011 08:14:52 GMT00000000-0000-0000-0000000013052it accept only key named "ID"? if I don't rename the key in the db (sorry, but I'm another user-SQL server express), when try to create controller in another project, it dosn't work

]]>Comment Posted by clahttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerTue, 03 May 2011 08:51:52 GMT00000000-0000-0000-0000000013055add: instead name Movie and Movies, I try to use Anagrafica and Anagrafiche (in italian)...

it dosn't work... only using Anagrafica and Anagraficas <- with ending "s"... my error or big bug?

]]>Comment Posted by sammie786http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 05 May 2011 09:19:48 GMT00000000-0000-0000-0000000013077I'm getting the same as Rema43001..

Could not load file or assembly 'file:///C:\blah\blah\blah\EntityFramework.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

I've already had SP1 and the tools update installed BEFORE i started this new project (started agin as advised by rick above) but I am still getting the same error as before.

This is so frustrating, can someone please help me out? I really want to get thru this tutorial, but with errors/issues like this, its really hindering my progress.

Thanks in advance

]]>Comment Posted by sammie786http://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 05 May 2011 09:22:29 GMT00000000-0000-0000-0000000013078I've checked the file path and the dll is there..

]]>Comment Posted by muaddibbhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 06 May 2011 02:42:12 GMT00000000-0000-0000-0000000013087I feel you, sometimes these tutorials pisses me off more than helping

"using System.Data.Entity"

- Right click References in your project

- Select Add References

- .NET tab scroll down to System.Data.Entity

]]>Comment Posted by muaddibbhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 06 May 2011 02:43:46 GMT00000000-0000-0000-0000000013088One more thing, don't forget to Rebuild Solution in order to select

Movie (MvcMovie.Models)

]]>Comment Posted by wintojdhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerFri, 06 May 2011 14:57:02 GMT00000000-0000-0000-0000000013090I had:

Could not load file or assembly 'file:///C:\Users\fiss\documents\visual studio 2010\Projects\MvcMovie\MvcMovie\bin\EntityFramework.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

Finally hit me that my docuements were being stored on the network and synched locally. Copied the project locally, worked without a problem.

]]>Comment Posted by khoaisanhttp://asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controllerThu, 12 May 2011 14:22:53 GMT00000000-0000-0000-0000000013143Why, I can't see Movies.sdf, although I did follow the guide

]]>