c# - Updating one record triggers changes of all the records for one of the same primary key in Entity Framework 6 -


i used ado.net entity data model entity framework of local db in vs project. there 1 table 2 composite primary keys (userid, data) , 1 modifiable field (status).

the problem is, when try retrieve 1 specific record , modify "status" field, "status" same userid change regardless value of data. (however records under different userid stay unaffected.) updating codes follows:

public void updatestatus(string userid, string data, short status)     using (var context = new mydbcontext()) {         var data = context.userdatastatus.single(s => s.userid == userid && s.data == data);         data.status = status;         context.userimagestatus.attach(data);         context.entry(data).property(p => p.status).ismodified = true;         context.savechanges();     } }

i tried many different ways update record, such using .where().firstdefault() retrieve record instead of single(), or adding .asnotracking() after context.userdatastatus. didn't work either.

i found entity framework doesn't handle correctly duplicated / no primary keys, example, have add .asnotracking() in query workaround when retrieving data same db. wonder if same reason cause updating problem, , how solve it?

====

updated:

well, i've found problem caused automatically generated ef models gave userid primary key. though chose "update model database" in .edmx, primary key didn't updated @ all. went .edmx model browser, manually update property of "data" field, , problem solved. , don't have use .asnotracking() in query anymore, too.

well, i've found problem caused automatically generated ef models gave userid primary key. though chose "update model database" in .edmx, primary key didn't updated @ all. went .edmx model browser, manually update property of "data" field (to set primary key), , problem solved. , don't have use .asnotracking() in query anymore, too.


Comments

Post a Comment

Popular posts from this blog

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more