background: database exposes crud operations stored procedures. want utilize advantages of dbcontext
including change tracking. out-of-box solution exists insert, update , delete operations:
protected override void onmodelcreating (dbmodelbuilder modelbuilder) { modelbuilder.entity<person>() .maptostoredprocedures(c => c.update(u => u.hasname("update_person") .parameter(p => p.id, "person_id") .parameter(p => p.name, "name")) .delete(d => d.hasname("delete_person") .parameter(p => p.id, "person_id")) .insert(i => i.hasname("insert_person") .parameter(p => p.name, "department_name"))); }
i found how select data stored procedure:
database.sqlquery<person>("select_persons", parameters);
here question: how can make dbcontext
perform change tracking of retrieved set of records? i'd able call savechanges()
?
for stored procedure select_persons
, should able do:
list<select_persons_result> mypeople = dbcontext.select_persons().tolist();
the class select_persons_result
automatically created when add sproc model.
i don't understand mean calling savechanges()
if doing select
.