c# - Entity Framework SaveChanges() not reflecting on entities -
i have winforms project , database running on sql server has 2 tables, student
, standard
.
first created ado.net entity data model database wizard thing. have datagridview
control has bindingsource datasource.
note: databindingprojection
class created able populate datagridview
properties both student
, standard
entities
i have code:
var query = context.students .include(s => s.standard) .select(s => new databindingprojection { studentid = s.studentid, studentname = s.studentname, dateofbirth = s.dateofbirth, height = s.height, weight = s.weight, standardname = s.standard.standardname, standard_standardid = s.standard.standardid }).tolist(); mylist = new bindinglist<databindingprojection>(query.tolist()); databindingprojectionbindingsource.datasource = mylist; databindingprojectiondatagridview.datasource = databindingprojectionbindingsource;
the grid populated however, when call context.savechanges()
, doesn't update database.
using select
method on dbset
project data non-entity class destroy link original data. in case, should bind student
class directly.
to bind properties in standard
class, can extends student
adding property because partial class.
partial class student { public standardname { { return this.standard.standardname; } set { this.standard.standardname = value; } } }
assuming standard
property never null.
Comments
Post a Comment