SaveChanges() method not saving changes to the database

Question

I just started with Entity framework and I was able to do select operations using linq,but I had an issue with Inserting. I tried this sample to see whats wrong :

 testEntities te = new testEntities(); te.Customer.Add(new Table {Id=1,Credit=200m,Name="test" }); te.SaveChanges();

Well it appears that the changes the row was only added to the testEntites but not to the database and when I restart the application I find no rows added. Thanks,

Do you get any errors? Try creating var t = new Table {Id=1,Credit=200m,Name="test" }; t.markAsAdded(); te.Customer.ApplyChanges(t); te.SaveChanges; — Giorgi Nakeuri
– Giorgi Nakeuri, Commented Feb 20, 2015 at 18:07
Also, what kind of database? If local sql server (express) database, check if you've set it to "copy to output: always". — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Feb 20, 2015 at 18:10
Are you using a local database file? Are you certain it's not getting overwritten when you build the solution? — D Stanley
– D Stanley, Commented Feb 20, 2015 at 18:36

Sandip Subedi · Accepted Answer · 2016-12-24 19:03:29Z

One way I fixed it was by making sure I was putting all the required fields on database. I was getting the same error before. I checked my database and I was not putting the not-nullable field when I was making the query. That solve my issue.

Lee Harrison · Accepted Answer · 2015-02-20 18:35:00Z

I had this problem while deleting records. Not sure what causes this, but I fixed it by forcibly changing the state of the entity. Some pseudo code:

Customer CustomerRecord = db.Customer.Find(Id); te.Entry(CustomerRecord).State = System.Data.Entity.EntityState.Added; te.SaveChanges();

Collectives™ on Stack Overflow

SaveChanges() method not saving changes to the database

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related