Entity Framework SaveChanges not saving to the database

Question

My code isn't erroring out or anything when I put a try catch around it, but yet it still does not save to the database. Is there something I am missing?

var newGroupMemberOf = new GroupMemberOf();
newGroupMemberOf.SamAcName = accountName;
newGroupMemberOf.MemberOf = parentSameAcName;
newGroupMemberOf.DateCreated = DateTime.Now;
newGroupMemberOf.DateUpdated = DateTime.Now;
newGroupMemberOf.IsActive = true;
newGroupMemberOf.Hidden = hidden;
newGroupMemberOf.ID = 12345678;

UserEntities.GroupMemberOf.Add(newGroupMemberOf);

UserEntities.SaveChanges();

and my entity set looks sort of like

public partial class UsersEntities : DbContext 
{ 
 public UsersEntities() 
    : base("name=UsersEntities") 
{ 
} 

protected override void OnModelCreating(DbModelBuilder modelBuilder) 
 {
  throw new UnintentionalCodeFirstException(); 
 }

 public virtual DbSet<GroupMemberOf> GroupMemberOf { get; set; }

As for the connection string, it is connecting to the DB since I do get results when I loop through the tables in other portions of the code — DanielJ
– DanielJ, Commented Oct 28, 2016 at 16:34

DanielJ · Accepted Answer · 2016-10-28 21:16:24Z

1

Turns out i was unable to add to the tables since I had mapped the tabled in the .edmx to Create, Update, and Delete stored procedures. Once I removed the mapping I was able to add and update

answered Oct 28, 2016 at 21:16

DanielJ

1071 gold badge4 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework SaveChanges not saving to the database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related