You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views. Any column that is not modified retains its original values, except in ...

Entity SQL and ObjectQuery will let you generate queries at runtime and still let you update your data through Entity Framework ... though. In an earlier column, I looked at using plain old SQL with ...