Part 4: Models and Data Accesshttp://asp.netThu, 01 Sep 2011 05:19:49 GMTumbracoComments for Part 4: Models and Data AccessenComment Posted by testudo52http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Wed, 27 Apr 2011 12:44:20 GMT00000000-0000-0000-0000000013001I received an error until I changed the connection string. Instead of

<connectionStrings>

<add name="MovieDBContext"

connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf"

providerName="System.Data.SqlServerCe.4.0"/>

</connectionStrings>

I used

<connectionStrings>

<add name="MusicStoreEntities"

connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf"

providerName="System.Data.SqlServerCe.4.0"/>

</connectionStrings>

]]>Comment Posted by sobinscotthttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Fri, 29 Apr 2011 14:27:57 GMT00000000-0000-0000-0000000013029Why do you change the code frquently?

]]>Comment Posted by Tim.Yamkuzahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Wed, 04 May 2011 16:44:16 GMT00000000-0000-0000-0000000013069I finished the step, "Updating the Store Index to query the database" and ran my project. When I click the Store link it bombs on, " var genres = storeDB.Genres.ToList();" telling me that it is, "Unable to fine the requested .Net Framework Data Provider". How do I fix this?

]]>Comment Posted by Tim.Yamkuzahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 05 May 2011 08:37:37 GMT00000000-0000-0000-0000000013076Never mind, it was my own failure to follow directions (I didn't install SQL Server CE).

]]>Comment Posted by michaelhouhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 09 May 2011 05:36:27 GMT00000000-0000-0000-0000000013103to Tim.Yamkuza:how to solve the problem.I meet the same error with you .

]]>Comment Posted by Tim.Yamkuzahttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 09 May 2011 11:21:31 GMT00000000-0000-0000-0000000013109The problem I had was I missed this part of the set up (see Part 1, Installing the software):

"We’ll be using the SQL Server Compact (also free) to host the database. Before you start, make sure you've installed the prerequisites listed below. You can install all of them using the following Web Platform Installer link: www.microsoft.com/

"

]]>Comment Posted by benfultonhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Sat, 14 May 2011 20:27:33 GMT00000000-0000-0000-0000000013167Took me a while to figure out that you have to select the project in Solution Explorer before the folders under "Add ASP.NET Folder" become enabled.

]]>Comment Posted by RonaldDiracthttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 30 May 2011 14:40:15 GMT00000000-0000-0000-0000000013326I cannot find the sample data in the Zip-file. Someone ideas?

]]>Comment Posted by RonaldDiracthttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 30 May 2011 15:06:11 GMT00000000-0000-0000-0000000013327Never mind, found it on the web. Great tutorials BTW!

]]>Comment Posted by deldridghttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 30 May 2011 19:45:45 GMT00000000-0000-0000-0000000013328Great tutorial - many thanks!

One little thing - in the MusicStoreEntities.cs class, I don't recall adding a DBSet for the Artists model, yet after running the app, it's magically appeared under the DBSet entries for Albums and Genres.

Have I missed something? Note, the tutorial (see "Adding a Context Class") doesn't say to add the line: [ public DBSet<Artist> Artists { get; set; } ] yet it now exists!

It would be nice to understand the EF implications of this if there are any!

Many thanks,

Dave (Sydney, Aust)

]]>Comment Posted by darkrider23http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 02 Jun 2011 10:22:31 GMT00000000-0000-0000-0000000013367great tutorial but restrictive - must use a particular db, must use EF 4.1 - this isn't very practical in the real world. I understand MS wants to introduce us to its new tools but its also not as helpful

]]>Comment Posted by lisabaker3494http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 02 Jun 2011 13:07:31 GMT00000000-0000-0000-0000000013369i had to change the connection string from MvcMusicStore.sdf to MvcMusticStore.mdf ...

]]>Comment Posted by bpatinhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 02 Jun 2011 15:29:17 GMT00000000-0000-0000-0000000013371Try to add a boolean field in your model and save it to the database. Since SQL Server has no bool datatype, you must use an int, but that won't work. I've seen example wrappers using MVC 2, but the technique won't work in MVC 3, because the data annotations are different, and I see no equivalent.

]]>Comment Posted by SledGimphttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 09 Jun 2011 17:25:07 GMT00000000-0000-0000-0000000013469I also finished the step, "Updating the Store Index to query the database" and ran my project. When I click the Store link it bombs on, " var genres = storeDB.Genres.ToList();" telling me that it is, "Unable to fine the requested .Net Framework Data Provider". My problem is that I have SQL Enterprise 2008 installed not compact, how do I get around this?

]]>Comment Posted by stevek123http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Fri, 17 Jun 2011 18:41:09 GMT00000000-0000-0000-0000000013550An answer to SledGimp's question would be appreaciated. I have a similar issue. Heading over to Google to look for an answer.

]]>Comment Posted by stevek123http://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Fri, 17 Jun 2011 18:51:29 GMT00000000-0000-0000-0000000013551To address SledGimp's (and my) problem: I changed the <connectionStrings> value to this and it seemed to work

<connectionStrings>

<add name="MusicStoreEntities" connectionString="Data Source=.;Initial Catalog=MvcMusicStore.sdf;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

I don't know if it is correct, but the expected page comes up.

]]>Comment Posted by jasmine_jhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Sun, 19 Jun 2011 01:40:05 GMT00000000-0000-0000-0000000013556Please help, I am stuck at adding the App_Data directory.

When I try to add the App_Data directory (From Project -> Add ASP.NET Folder -> App_Data) all the items are disabled (App_GlobalResources, App_LocalResources, App_Data, App_Browsers, Theme), any ideas? thanks

]]>Comment Posted by erwanagehttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Wed, 29 Jun 2011 04:46:36 GMT00000000-0000-0000-0000000013636I created a premade internet application with ASP.NET MV3 using visual studio 2010.

I want to manage an user database but my table is created in aspnetdb.mdf.

I'd like to konw if it's possible to create a context class linked to the aspnet_membership table.

regards

]]>Comment Posted by demonotterhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 30 Jun 2011 07:03:02 GMT00000000-0000-0000-0000000013644Hey,

I have a problem with a connection string on MS SQL Server 2008 Express

<connectionStrings>

<add name="MusicStoreEntities"

connectionString="Server=.\sqlexpress; Database=MvcMusicStore; User Id=id;password=pass"

providerName="System.Data.SqlClient" />

</connectionStrings>

This connection string works when I put it into a complete project

But when I'm trying to use it on the current step, I have an Error:Login failed for user

Help me with it please, spent three hours solving this problem(

]]>Comment Posted by frogjezzhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Mon, 04 Jul 2011 13:40:31 GMT00000000-0000-0000-0000000013681I think I followed the tutorial exactly, but I have this error when trying to update the store index to query the database:

Error point on this line --> var genres = storeDB.Genres.ToList();

-----

One or more validation errors were detected during model generation:

System.Data.Edm.EdmEntityType: : EntityType 'Album' has no key defined. Define the key for this EntityType.

System.Data.Edm.EdmEntitySet: EntityType: EntitySet �Albums� is based on type �Album� that has no keys defined.

]]>Comment Posted by tjvaderhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 18 Aug 2011 09:17:19 GMT00000000-0000-0000-0000000013981I have the same problem with the following StoreController --> var genres = storeDB.Genres.ToList();. I currently have two versions of SS CE install, v3.5 and v4.0. The v3.5 is from SQL Server 2005 CE and the SQL Server CE4.0 I downloaded from MS. I am using my Win 7 64bit machine.

TomJ

]]>Comment Posted by mr Eugenehttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 18 Aug 2011 15:37:10 GMT00000000-0000-0000-0000000013986Nice tutorial. I would like to ask a simple question: how can I use other databases (for e.g. SQL Server 2005)?

]]>Comment Posted by ematsunohttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 18 Aug 2011 17:23:54 GMT00000000-0000-0000-0000000013988So, I can't find the VS 2008 version. Anyone?

]]>Comment Posted by tjvaderhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Sun, 21 Aug 2011 03:10:16 GMT00000000-0000-0000-0000000013999I did a little bit more snoopying and found that this tutorial works as expected ON-THE-32BIT side of Win 7. All of my problems exist on the 64bit side of the OS. :-(

TomJ

]]>Comment Posted by Scott.Mermelsteinhttp://asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-4Thu, 01 Sep 2011 05:19:49 GMT00000000-0000-0000-0000000014098Is there any particular reason that Genre in this example is marked as a partial class? I removed the partial in my code, and it seemed to behave as expected, but wasn't sure if EF requires it. If so, why does it require it only for that class, and no other?

]]>