Ignore optional columns on save

Question

When I update a table from a Form through Autogenerated EF, if I remove some data-columns from the view form because I don't want to be editable, that columns are updated with null value, how can avoid this behavior? I read here: Entity Framework: Ignore Columns removing it from the model, but not always I want to ignore these datacolumns.

thank!

Steve Mallory · Answer 1 · 2011-05-20T19:23:51.857

3

Another approach is to use annotations

[HttpPost]
public virtual ActionResult Edit(
    [Bind(Prefix="", Include="field1", Exclude="field2")]MyClass myClass)
{
  ....

edited May 20 '11 at 19:23

answered May 20 '11 at 19:13

Steve Mallory

4,245
1
28
31

score 2 · Accepted Answer · answered May 20 '11 at 18:35

2

asp.net MVC provide you with UpdateModel method, look on the overload

protected internal void UpdateModel<TModel>(
TModel model,
string prefix,
string[] includeProperties,
string[] excludeProperties
)
where TModel : class

using it you are able to exclude or include particular properties by their names

answered May 20 '11 at 18:35

vittore

17,449
6
44
82

Thanks, I'm trying to understand how it works, seems the rigth solution – Santiago May 20 '11 at 18:57
Excelent! I only have to replace the db.MyTable.Attach(mytable); for UpdateModel(mytable); – Santiago May 20 '11 at 19:09

Ignore optional columns on save

2 Answers2

Linked