Saving data in multiple database sets

Question

I have a database context with multiple database set. I have an edit (httpget) and an edit (httppost) method. I want to save specific data in specific datasets. How can I specify which database set I want to use? BTW, the view from of the Edit method uses several models.

My database context looks like this:

public class mycontext :DBContext
{
  public DBSet<Table1> table1{get; set;}
  public DBSet<Table2> table2{get; set;}
  public DBSet<Table3> table3{get; set;}
}

When I define

private mycontext data = new mycontext()

The only option is data.SaveChanges(). I want to so something like data.table1.SaveChanges() and pass in the data I want to save.

The whole point of the DbContext in Entity Framework is that it keep track of the changes itself, and saves out whatever is needed, all in one transaction, when you call .SaveChanges() on it. You cannot just save half the changes, on one table - all the changes you've made to the context will be saved - all at once — marc_s
– marc_s, Commented Dec 21, 2012 at 16:42
Thanks. But say I have a field whose value depend on the button clicked to submit the form and I need to update that field in the table. How will I do that please? — jpo
– jpo, Commented Dec 21, 2012 at 18:51

lante · Accepted Answer · 2012-12-21 17:08:32Z

1

if you only want to update data in Table1, modify only data in Table1, and then call .SaveChanges()

answered Dec 21, 2012 at 17:08

lante

7,3924 gold badges39 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving data in multiple database sets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related