tag:blogger.com,1999:blog-6082652835152798567.post7971203899245309774..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Part 28 - Customizing the autogenerated edit viewUnknownnoreply@blogger.comBlogger13125tag:blogger.com,1999:blog-6082652835152798567.post-72126108757350731872023-07-14T02:35:41.290-07:002023-07-14T02:35:41.290-07:00for visual studio 2019
[HttpPost]
...for visual studio 2019<br /><br /> [HttpPost]<br /> [ValidateAntiForgeryToken]<br /> public ActionResult Edit([Bind(Include = "EmployeeId,Gender,City,DepartmentId")] Employee employee)<br /> {<br /> Employee employeeFromDb = db.Employees.Single(x => x.EmployeeId == employee.EmployeeId);<br /> <br /> employeeFromDb.EmployeeId = employee.EmployeeId;<br /> employeeFromDb.Gender = employee.Gender;<br /> employeeFromDb.City = employee.City;<br /> employeeFromDb.DepartmentId = employee.DepartmentId;<br /> employee.Name = employeeFromDb.Name;<br /><br /> if (ModelState.IsValid)<br /> {<br /> db.Entry(employeeFromDb).State = EntityState.Modified;<br /> db.SaveChanges();<br /> return RedirectToAction("Index");<br /> }<br /> ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Name", employee.DepartmentId);<br /> return View(employee);<br /> }Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-17546811166078754452018-09-26T16:26:28.209-07:002018-09-26T16:26:28.209-07:00make sure that you are used the nvarchar type in t...make sure that you are used the nvarchar type in the database for gender and no nchar because nchar is fixed-length which will reserve storage space for number of characters you specify even if you don't use up all that space.<br />But nvarchar is variable-length which will only use up spaces for the characters you store. It will not reserve storage like char or nchar.Anonymoushttps://www.blogger.com/profile/01733487864596470976noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-46294649459245045142017-03-06T22:22:31.202-08:002017-03-06T22:22:31.202-08:00public ActionResult Edit([Bind(Exclude = "Nam...public ActionResult Edit([Bind(Exclude = "Name")] Employee employee)<br /> {<br /> Employee employeeFromDB = db.Employees.Single(x => x.EmployeeId == employee.EmployeeId);<br /><br /> employeeFromDB.EmployeeId = employee.EmployeeId;<br /> employeeFromDB.Gender = employee.Gender;<br /> employeeFromDB.City = employee.City;<br /> employeeFromDB.DepartmentId = employee.DepartmentId;<br /> employee.Name = employeeFromDB.Name;<br /><br /> if (ModelState.IsValid)<br /> {<br /> db.Entry(employeeFromDB).State = EntityState.Modified;<br /> db.SaveChanges();<br /> return RedirectToAction("Index");<br /> }<br /> ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Name", employee.DepartmentId);<br /> return View(employee);<br /> }Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-59175859573784999772016-11-22T22:04:59.398-08:002016-11-22T22:04:59.398-08:00db.ObjectStateManager is still not resolved gettin...db.ObjectStateManager is still not resolved getting compile time error. How to fix this ?Anonymoushttps://www.blogger.com/profile/07843236353938360781noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-72734798434872501482015-08-18T04:59:03.883-07:002015-08-18T04:59:03.883-07:00Hi! i'm following your videos and awesome, sir...Hi! i'm following your videos and awesome, sir i'm using vs13. i'm facing a error when i compile my code. the browser generates a error Compilation Error : public class _Page_Views_Employee_Index_cshtml : System.Web.Mvc.WebViewPage> {<br />don't know why this error occurs, please help meKing Khanhttps://www.blogger.com/profile/18026782690134481990noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-42489088649168965792015-04-10T04:59:56.634-07:002015-04-10T04:59:56.634-07:00Please help me how to solve this issue ,I have sea...Please help me how to solve this issue ,I have searched so much but cannot finding any answer/solution on this, I am using <br />MVC 4 and EF 5.0 with VS 2013Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-56124559902644287162015-04-07T05:41:06.526-07:002015-04-07T05:41:06.526-07:00hi John,
Thanks for posting, but I still have an e...hi John,<br />Thanks for posting, but I still have an error with the method that you suggest adding into EmployeeContext: <br /><br />public ObjectContext ObjectContext()<br /> {<br /> return (this as IObjectContextAdapter).ObjectContext;<br /> }<br /><br />Error: EmployeeContext.ObjectContext() is a 'method' but is used like a 'type'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-31721967531674396372015-03-02T14:05:34.374-08:002015-03-02T14:05:34.374-08:00I was having problems as well with ObjectStateMana...I was having problems as well with ObjectStateManager not existing in my db context but I figured out a solution that works.<br /><br />Create a new partial class named EmployeeContext.cs in your project. The location doesn't matter but I put in in the 'Models' folder so it would be close to the auto generated 'EmployeeDataModel.Context.cs' file which contains the definition for the public partial class EmployeeContext:<br /><br />namespace MVCDemo.Models<br />{<br /> using System;<br /> using System.Data.Entity;<br /> using System.Data.Entity.Infrastructure;<br /> <br /> public partial class EmployeeContext : DbContext<br /> {<br />.....<br /><br />Open the file EmployeeContext.cs that you added to the project. By default, it should look similar to this:<br /><br /><br />namespace MVCDemo<br />{<br /> public class EmployeeContext<br /> {<br /> }<br />}<br /><br /><br />Do the following to this class:<br />1. Make this class a partial EmployeeContext class<br />2. Add the following using statements: System.Data.Entity and System.Data.Entity.Infrastructure<br />3. Make this class inherit from DbContext<br />4. Add the following method:<br />public ObjectContext ObjectContext()<br />{<br /> return (this as IObjectContextAdapter).ObjectContext;<br />}<br /><br />Now return to the line you were having problems with and change db.ObjectStateManager.ChangeObjectState(employeeFromDB, EntityState.Modified);<br />TO<br />db.ObjectContext().ObjectStateManager.ChangeObjectState(employeeFromDB, EntityState.Modified);<br /><br />Notice that you will have a new method available off of db and it is db.ObjectContext() from there you can access all of ObjectContext in it's full glory!<br /><br />Hope this help!<br />John<br />John Gilmore, Jr.https://www.blogger.com/profile/13012032048798616926noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-60397330824000174502015-02-22T05:53:34.135-08:002015-02-22T05:53:34.135-08:00Salam Sir Venkat, Why does the ObjectStateManager ...Salam Sir Venkat, Why does the ObjectStateManager property not exist in my db context?Anonymoushttps://www.blogger.com/profile/10491004173069734602noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-26313552254003083992015-01-07T12:21:24.521-08:002015-01-07T12:21:24.521-08:00Hi Prahim,
I am using entityframework 6.1 MVC 4
T...Hi Prahim, <br />I am using entityframework 6.1 MVC 4<br />Two questions:<br />1. Is it true that in this version of Entity, we do not need to create additional Metadata Models as they exist already? Or they still get regenerated?<br />2. I understand why @ 10:50 you remove the [Required], but does this not allow users to Create entry without Name? Could you please explain how to fix this?<br /><br />Thanks for all your Videos, very well explained! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-1029082411387574392014-11-03T04:03:23.612-08:002014-11-03T04:03:23.612-08:00Check all my comment in Part 8 about MVC4 vs, MVC ...Check all my comment in Part 8 about MVC4 vs, MVC 5 and you know exactly why you have these problems.Harryhttps://www.blogger.com/profile/18393651814863688678noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-58577327472062921752014-11-01T01:12:02.581-07:002014-11-01T01:12:02.581-07:00Hi..
i have replaced this
@Html.EditorFor(model =...Hi..<br />i have replaced this <br />@Html.EditorFor(model => model.Gender)<br /><br />WITH<br />@Html.DropDownList("Gender", new List<br /> {<br /> new SelectListItem { Text = "Male", Value="Male" },<br /> new SelectListItem { Text = "Female", Value="Female" }<br /> }, "Select Gender")<br /><br />But dropdownlist doesnt show the value of the selected record.....<br />i m using entityframework 5.0 mvc4...<br />plz help meBeing Positivehttps://www.blogger.com/profile/15874354251556419516noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-86309593828527040482014-07-24T15:30:42.655-07:002014-07-24T15:30:42.655-07:00Hi venkat, I'm using MVC 5, why I can not reso...Hi venkat, I'm using MVC 5, why I can not resolve db.ObjectStateManager?Anonymoushttps://www.blogger.com/profile/04882086280029496326noreply@blogger.com