Updating Model with Not Mapped property in Entity Framework

Question

I have this scenario where my model contain one propery which is not mapped , but its mendatory for the model as i am getting this as input from user, now when i want to update this model(table) i get exception for this property , that it cannot be null.

[NotMapped]
[Required(ErrorMessage = "Please Enter UserName")]
public string UserName { get; set; }

my Code when i want to update few fields, i am assigning username with value, which i don't think so i should. This User Name value is not affecting anything , but curious if there is a way to not modify it.

Orders order;
order = db.Orders.FirstOrDefault(o => o.ID.CompareTo(model.OrderID) == 0);
      if (order == null)
          {
             throw new Exception(Resources.WrongOrderID);
          }
     else
          {
             order.Order_Status = 1;
             order.Close_Order_User_ID = cmuser.ID;
             var dateQuery = db.Database.SqlQuery<DateTime>("SELECT NOW()");
             DateTime serverDate = dateQuery.AsEnumerable().First();

             order.Close_Order_Date = serverDate;
             order.UserName = cmuser.USER_NAME;
             db.Entry(order).State = EntityState.Modified;

             //db.Entry(order).Property(o => o.UserName).IsModified = false;

            db.SaveChanges();

            return Ok(Resources.OrderClosed);

   }

in the above code there is one commented line, i tried this but it will give exception of that "Is Modified cannot be used for the property which dont belong to model"

Do i have to add something in my function check below:

[Route("CloseOrder")]
public IHttpActionResult CloseOrder([something over here??]CloseOrderBinding model)

Please Advise.

User3250 · Answer 1 · 2017-05-08T14:20:21.677

0

If I understand correctly you need this:

public IHttpActionResult CloseOrder([[Bind(Exclude = "UserName")]CloseOrderBinding model)

and

ViewData.ModelState.Remove("UserName");

edited May 08 '17 at 14:20

answered May 08 '17 at 13:40

User3250

2,961
5
29
61

Yes , but it still gives error `Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.`. i added like this `public IHttpActionResult CloseOrder([System.Web.Mvc.Bind(Exclude = "UserName")]CloseOrderBinding model)` – Nisar Afridi May 08 '17 at 13:56
Please add this ViewData.ModelState.Remove("UserName") – User3250 May 08 '17 at 14:21
1

ViewData is part of which namespace or reference. it says its not part of this context. – Nisar Afridi May 08 '17 at 14:31
its in System.Web.Mvc. You using Webapi? – User3250 May 08 '17 at 14:38
Yes, I am using WebApi – Nisar Afridi May 08 '17 at 14:40

Updating Model with Not Mapped property in Entity Framework

1 Answers1