Implementing Basic CRUD Functionality with the Entity Framework in ASP.NET MVC Application (2 of 10)http://www.asp.netFri, 25 Jan 2013 13:03:58 GMTumbracoComments for Implementing Basic CRUD Functionality with the Entity Framework in ASP.NET MVC Application (2 of 10)enComment Posted by mejamzhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationThu, 21 Apr 2011 23:31:58 GMT00000000-0000-0000-0000000012928Excellent video, moving on to the next one; I really appreciate the explanations and links to more information... finally, a video series I can follow and one that resolves several issues for me... thank you

]]>Comment Posted by ptn1http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 23 May 2011 15:25:05 GMT00000000-0000-0000-0000000013252Following the Steps. I have a System.NullReferenceException error at @foreach (var item in Model.Enrollments). Exploring Model.Enrollments debug shows Null for Enrollments property. I am assuming I have a problem in the Model but nothing is obvious. Any suggestions?

]]>Comment Posted by ptn1http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 23 May 2011 15:29:14 GMT00000000-0000-0000-0000000013253Found the issue (of course) after I submitted the comment. I was missing "virtual" in the Enrollment collection definition in the Student class.

public class Student

{

...

public virtual ICollection<Enrollment> Enrollments { get; set; }

}

]]>Comment Posted by obdensehttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 30 May 2011 08:17:22 GMT00000000-0000-0000-0000000013323Excellent tutorial.

]]>Comment Posted by bpatinhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationTue, 26 Jul 2011 11:13:53 GMT00000000-0000-0000-0000000013838Many if not most enterprises with complex data structures expect to use stored procedures for their CRUD operations, and database views, not necessarily updateable, to actually read the data, and I would really like tutorials on how to set up a project that primarily does that. Too many new Microsoft developers seem to be afraid to work with SQL these days, but the MVC and Entity Framework they have tried to sell us are essentially incomplete and unusable in a large enterprise without these capabilities. Stored procedures in the database can often get the job done much more quickly and effectively that trying to do everything in code.

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationFri, 29 Jul 2011 18:12:23 GMT00000000-0000-0000-0000000013877@bpatin - Thanks for the comment. EF 4.0 Database First supports stored procedures -- see the first of the three EF tutorial series on this site. EF Code First does not support stored procedures yet, but it is on the list of planned enhancements for the future. In Code First you can call stored procedures but you have to do it manually the same way you would execute a SQL statement; the last tutorial in this series shows how to do that.

]]>Comment Posted by Ne7venhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationWed, 03 Aug 2011 13:50:02 GMT00000000-0000-0000-0000000013896at step create Edit views, after i resembled demo code and add view to my HttpPost Edit method and F5 to run code, debug point at first line of Edit Method, but when i clicked save nothing happen. please help

]]>Comment Posted by oppdalhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 08 Aug 2011 09:23:54 GMT00000000-0000-0000-0000000013927I don't see the dispose method in my StudentController.cs

]]>Comment Posted by ricka6http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationTue, 16 Aug 2011 20:37:37 GMT00000000-0000-0000-0000000013974oppdal : dispose method in my StudentController.cs

The MVC scaffolding system automatically adds this. If you followed the instruction on the previous page "Creating a Student Controller", the Dispose override is automatically added to the end of the StudentController class.

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationTue, 23 Aug 2011 14:57:57 GMT00000000-0000-0000-0000000014023@Ne7ven - If you're stopped at a breakpoint you will have to continue from the breakpoint in order for the web page to work.

]]>Comment Posted by payinihttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 03 Oct 2011 19:07:02 GMT00000000-0000-0000-0000000014322Great Tutorial!

Thanks.

]]>Comment Posted by SavantKing10http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 02 Apr 2012 07:32:00 GMT00000000-0000-0000-0000000015237How U can make an submenu item navigation. For example u want to have some subitmes vertical under the parent menu: Students. How to will manage that?? I am looking in the internet but I dont see any solutions in the internet. Can u give me an example . THX!!

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationThu, 12 Apr 2012 22:03:10 GMT00000000-0000-0000-0000000015315@SavantKing10 - For questions not directly about the content of the tutorial, it's best to post them to the appropriate ASP.NET forum, in this case that would probably be the MVC forum: forums.asp.net/

]]>Comment Posted by nhajjehttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationSun, 22 Apr 2012 00:37:03 GMT00000000-0000-0000-0000000015389Never mind, I finally figured it out. I had created the "EnrollmentDateGroup.cs" file in the Models folder and then moved it to the ViewModels Folder. When I created the file in the Models folder it assigned the namespace as "namespace ContosoUniversity.Models". Since I moved the file to "ViewModels" it kept the namespace name the same. The fix was to rename the namespace to "namespace ContosoUniversity.ViewModels". Its best to delete the file and recreate it in the "ViewModels" folder.

]]>Comment Posted by Richard Scannellhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationMon, 30 Apr 2012 06:09:30 GMT00000000-0000-0000-0000000015433I have got the full tutorial working, but am confused about the different subfolders & what goes where. 4 folders are 'data related' & they seem to overlap:

'Models' has entity definitions & validation rules . (Classic MVC - I get this!)

'App_Data' contains a pointer to the actual data tables. ( Also clear).

DAL & ViewModels are where my confusion arises.

In DAL, what is the function of the *Repository & *Context files?

What are the ViewModels - why aren't they in Models?

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationWed, 16 May 2012 15:08:40 GMT00000000-0000-0000-0000000015530@Richard Scannell - DAL stands for Data Access Layer. The classes in this folder are related to working with the database. You'll often see them in a separate class library project but for simplicity they're in a folder here. The ViewModels folder is for models that are created only for passing data to and from an MVC view. So for instance, the Student class is in Models: you use it in many different contexts and it represents an actual entity that the application works with. The EnrollmentDateGroup class is in ViewModels because it is a special-purpose class for use only with one MVC view.

]]>Comment Posted by jota2007http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationWed, 13 Jun 2012 11:00:06 GMT00000000-0000-0000-0000000015762One more step successfully completed!! Thanks!

]]>Comment Posted by Nithin Prakashhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationSat, 23 Jun 2012 22:15:40 GMT00000000-0000-0000-0000000015834Thanks for the detailed explaination:)

]]>Comment Posted by gopi_krishnaghttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationWed, 18 Jul 2012 12:48:05 GMT00000000-0000-0000-0000000016004hi Nice article, here i am having a doubt , In the Students detail page, Students Enrollments details are appearing, how to add the enrollment details while add/modify the student page. please let me know

]]>Comment Posted by tdykstrahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationThu, 19 Jul 2012 20:57:46 GMT00000000-0000-0000-0000000016014#gopi_krishnag - The Edit Get method retrieves the entity by using the same method that the Details method uses; you should be able simply to add the same Razor code to the Edit view that displays the enrollments in the Details view.

]]>Comment Posted by victorwoohttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationTue, 07 Aug 2012 02:28:28 GMT00000000-0000-0000-0000000016124If I want the SQL Update statement to update only the fields that the user actually changed, what's the difference of by using Find() & by using Attatch() ?

]]>Comment Posted by juliandormonhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationWed, 22 Aug 2012 19:06:15 GMT00000000-0000-0000-0000000016261Thanks for for this great tutorial! The scaffolding from objects is a real time saver but I feel daft when dealing with partial updates. What is the proper way to create a view that contains a form with fields that correspond with only a few database columns? And what is the proper way to handle a partial entity/record update for that form? I cannot hide all the entity values in hidden form variables for various security reasons. Thanks!

]]>Comment Posted by gagouchehttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationFri, 28 Sep 2012 14:14:50 GMT00000000-0000-0000-0000000016542Thank you so much for this tutorial.

Question:

I was experiment with the code, and I change the details. Why would the code below work?

var student = db.Students.Include("Course").Include("Enrollment").Single(a => a.StudentID == id);

]]>Comment Posted by suicidahttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationTue, 09 Oct 2012 11:37:52 GMT00000000-0000-0000-0000000016593Hi Tom,

My Browser language is en-CA and not en-US which I assume you were using. So I tried to change the EnrollmentDate of a Student (or any Date for any object) and the Validation didn't accept values in the format "DD/MM/YYYY". The only solution was adding the <globalization culture="en-US" uiCulture="auto" /> line in Web.config. However I'm curious how can you implement the validation for another Cultures?

Thank you!

]]>Comment Posted by kammerhttp://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-applicationFri, 25 Jan 2013 13:03:58 GMT00000000-0000-0000-0000000018251Thanks you so much, Tom !!!

Boris.

Russia.

]]>