c# - Can't insert row on DB2 w/ EF5 -


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