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.
