i have wpf app running against db2 9.1 (z/os) using ef5. works fine except inserting primary key integer(10) field.
the entity has mapped property int type.
private models.userinfo getuserinfo(string emplid, string firstname, string lastname) { if (string.isnullorempty(emplid)) return null; int _emplid = convert.toint32(emplid.trim()); try { using (var ctx = new data.timscontext()) { var user = (from u in ctx.query<data.entities.asnuser>() u.employeeid == _emplid select u).firstordefault(); if (user == null) { //add user database user = new data.entities.asnuser() { employeeid = _emplid, firstname = firstname.trim(), lastname = lastname.trim() }; ctx.set<data.entities.asnuser>().add(user); ctx.savechanges(); } return new models.userinfo() { employeeid = user.employeeid, displayname = string.format("{0}, {1}", user.lastname, user.firstname) }; } } catch (exception e) { throw; } }
this problem edmx file / ef model.
if employeeid field defined in model auto increment id, ef ignore value set , null sent database. database not have auto increment field, tries insert null.
Comments
Post a Comment