Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)http://asp.netFri, 27 May 2011 02:18:21 GMTumbracoComments for Creating an Entity Framework Data Model for an ASP.NET MVC Application (1 of 10)enComment Posted by maranhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationWed, 13 Apr 2011 15:18:24 GMT00000000-0000-0000-0000000012787You guys are rock :)

]]>Comment Posted by vincentliuhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 15 Apr 2011 00:43:07 GMT00000000-0000-0000-0000000012820Haven't seen such a good quality tutorial for a long time.

Thank you so much :)

]]>Comment Posted by abussie22http://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationMon, 18 Apr 2011 16:06:51 GMT00000000-0000-0000-0000000012857Good tutorial I've been researching EF and MVC and struggling with using the two. You're tutorial provided a good working example of how to use EF and MVC. I can't wait to move to the next tutorial; Rocking good job !!

]]>Comment Posted by airmarohttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 19 Apr 2011 17:38:23 GMT00000000-0000-0000-0000000012870Thanks for the tutorials.

In working through them when I copy/paste code from IE9 to VS2010 all the code is on one line and it's annoying to reformat it. Google Chrome copy/pastes with no formatting issues. Is there a setting in IE that I'm missing?

And, yes, I do realize that I can download the completed version. I just prefer to follow along.

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationWed, 20 Apr 2011 17:36:59 GMT00000000-0000-0000-0000000012891IE9 does that in all the newer tutorials on the ASP.NET due to the method they use for code formatting. You can get the correct behavior by doing this:

• Hit F12 in your browser.

• Select the Browser Mode menu, then click Internet Explorer 9 Compatibility View.

]]>Comment Posted by johnnyo_onthegohttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 22 Apr 2011 15:56:21 GMT00000000-0000-0000-0000000012935I'm very grateful for this tutorial so far, but I ran into one minor issue. I am not sure it was mentioned in the tutorial somewhere, I apologize if I missed it. In case someone is not familiar with the EF, you must download the EF and then reference the binary EntityFramework.dll in your project in order to gain access to the DbContext.

Thanks,

John

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationSat, 23 Apr 2011 17:11:11 GMT00000000-0000-0000-0000000012950@johnnyo onthego - Thanks for the observation. As a result of installing the MVC 3 Tools Update this reference should be automatically set. (It should also be done automatically for you if you get EF in the NuGet package named "EntityFramework".) Did you install the Tools Update before starting the tutorial?

]]>Comment Posted by mcorneluishttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationMon, 25 Apr 2011 23:25:15 GMT00000000-0000-0000-0000000012971How do you make your Add Controller page show all those options listed above.

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 01:07:32 GMT00000000-0000-0000-0000000012972If you aren't seeing all those options, it's probably because you have not yet installed the MVC 3 Tools Update. This is an add-on update to MVC 3 that was just released about two weeks ago. There is a link for using Web Platform Installer to install it at the top of the tutorial.

]]>Comment Posted by vikphttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 09:01:21 GMT00000000-0000-0000-0000000012981How do we go about creating models from database tables? This example generates SQL tables from specified classes, but what if we generate classes from SQL tables? Thank you

]]>Comment Posted by johnnyo_onthegohttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 13:22:00 GMT00000000-0000-0000-0000000012985@tdykstra - I did not download the tools update... that's probably where I missed it... thanks for the update!

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 13:54:05 GMT00000000-0000-0000-0000000012986@vikp - For a Database First tutorial see the first of these three series at

www.asp.net/

There's an older Database First MVC tutorial at

www.asp.net/

]]>Comment Posted by eyalbhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 14:47:47 GMT00000000-0000-0000-0000000012989when using sqlexpress i get an error

"Model compatibility cannot be checked because the database does not contain model metadata. Ensure that IncludeMetadataConvention has been added to the DbModelBuilder conventions."

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationTue, 26 Apr 2011 15:33:36 GMT00000000-0000-0000-0000000012990@eyalb - I haven't seen that error but have not been using Code First with SQL Express very much. I suggest submitting it to one of the forums listed above or to StackOverflow.

]]>Comment Posted by vikphttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationWed, 27 Apr 2011 17:40:48 GMT00000000-0000-0000-0000000013003Hi :)

The article has said in the "POCO (Plain Old CLR Objects)" chapter that both code first and database first methodologies provide models that inherit from EntityObject class, therefore they are NOT persistence-ignorant.

Then it says: "All development approaches of the Entity Framework ..... you'll use POCO classes."

So do we just use objects that inherit from EntityObject and ignore the fact that they have persistence functionality attached to them? Or am I misunderstanding something?

Thank you

]]>Comment Posted by praetorxynhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationWed, 27 Apr 2011 20:35:39 GMT00000000-0000-0000-0000000013006I just have a quick question and this seems the best place to ask it because this is the part of the tutorial it pertains to.

Instead of having a DAL folder, say you had a separate project (class library) in the same solution called DAL. And you also had a separate project (class library) called BLL where you store your repositories. So the BLL project references the DAL project, which references the ContosoUniversity project to access it's POCO Models, and the ContosoUniversity project references the BLL project to interact with the repositories. I think this really enforces a better separation of concerns, because the POCO classes in the main project are totally ignorant of all things entity framework, or that's my theory at least.

The problem I have is, with a setup like this, how can you register the database initilizer in the global.asax file? You would have to add a reference to the DAL project to do this the same way it's done above, which would create a circular reference.

Thanks in advance for any answers you can provide.

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationThu, 28 Apr 2011 19:10:45 GMT00000000-0000-0000-0000000013015@vikp The first part of that section indicates that Database First and Model First (not Database First and Code First) entity classes inherit from EntityObject by default. This is just a default, you can also use classes that do not inherit from EntityObject with Database First and Model First. The default in Code First is to use entity classes that do not inherit from EntityObject.

@praetorxyn That's a good question but as it's outside the scope of these tutorials I'd recommend posing it to StackOverflow or the ASP.NET EF forum.

]]>Comment Posted by marcostafhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 29 Apr 2011 06:47:40 GMT00000000-0000-0000-0000000013024I created, using scaffolding, also the controller for Course and Enrollment.

I delete a course and I see that also the enrollment that link that course to students has been deleted.

Perfect!

I see that when the Db is genereated, the generator create also the relation in the table Enrollment.

Great!

The relations that it create are:

- Course_Enrollments

- Enrollment_Student

I don't understand why the name of the firts relation use pluralization

("Course_Enrollments") and why the the order of the table is inverted respect the "Enrollment_Student".

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 29 Apr 2011 16:43:45 GMT00000000-0000-0000-0000000013036@marcostaf - In my database, the first of the relations you mention is named Enrollment_Course, and so the order is explainable because both start with Enrollment; I don't know why you are getting one with Course first and Enrollment pluralized. Are all of your attributes in Course and Enrollment, and all of your context class API calls, the same as what's in the tutorial?

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 29 Apr 2011 17:41:39 GMT00000000-0000-0000-0000000013037Also, thanks to everyone who has offered questions, comments, and compliments. The questions and comments often help identify parts of the tutorial that may need to be made clearer, and the positive responses encourage us to continue producing tutorials like these.

]]>Comment Posted by KKWWhttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationSun, 22 May 2011 23:21:13 GMT00000000-0000-0000-0000000013247Have had no luck getting past service pack 1 install,,, keeps failing not finding devenv.exe.config on windows 7 64, have been searching for soluton.. no luck ....Kkww

]]>Comment Posted by ninibini1http://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationMon, 23 May 2011 15:55:57 GMT00000000-0000-0000-0000000013254Thanks for another great tutorial.

]]>Comment Posted by ssathyahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationThu, 26 May 2011 17:27:37 GMT00000000-0000-0000-0000000013285Great tutorial. Can we get the entire set as a word/mobi/epub document? Would be convenient to store in a ebook reader.

]]>Comment Posted by tdykstrahttp://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationThu, 26 May 2011 21:44:33 GMT00000000-0000-0000-0000000013286@ssathya - We will be providing it in .pdf form and will add a comment here when that's ready.

]]>Comment Posted by pseudo70http://asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-applicationFri, 27 May 2011 02:18:21 GMT00000000-0000-0000-0000000013288I think I have found another error in this tutorial (thanks for changing the previous error). You wrote: "The StudentID property is a foreign key, and the corresponding navigation property is Student. An Enrollment entity is associated with one Student entity, so the property can only hold a single Student entity (unlike the Student.Enrollments navigation property you saw earlier, which can hold multiple Enrollment entities).

The CourseID property is a foreign key, and the corresponding navigation property is Course. An Enrollment entity is associated with one Student entity."

In the last paragraph it should mean: "An Enrollment entity is associated with one COURSE entity". Because your sentence prior the last is related to the relationship between Course and Enrollment entities. In fact both paragraphs contain the sentence: "An Enrollment entity is associated with one Student entity...". But only the first occur should be right.

]]>