Entity Framework Save not working

Question

I am using Entity Framework to save some data in a SQLite database file.

This is my table in DB file

ID  Name    Username    Pwd

ID is autoincrement, and rest of columns are of Text type

This is how I am saving my data into the database:

UserInfo userInfo=new UserInfo();
userInfo.Name="abc";
userInfo.Username="xyz";
userInfo.Pwd="123456";

using (var context = new ApplicationContext())
{
    context.UserInfo.Add(userInfo);                
    context.SaveChanges();
}

The problem is, this code is not inserting any new row into the table. I also tried this before saving, but no luck

context.Entry<UserInfo>(userInfo).State = EntityState.Added;
context.ChangeTracker.DetectChanges();

I tried debugging and no exception is occurring.

How can I insert new row into a table using Entity Framework?

connection string? your logic is fine, my first guess is that your connection string is a bit funky! — Callum Linington, Nov 07 '14 at 11:01
Is it all wrapped in a try/catch block and you are ignoring errors perhaps? — DavidG, Nov 07 '14 at 11:03
Connection String is fine, its retrieving the existing data but not saving — Syed Salman Raza Zaidi, Nov 07 '14 at 11:03

RajeshKdev · Answer 1 · 2014-11-07T12:05:38.907

0

Possibilities that may cause an issue.

Right Click on your Entity Data Model and Update Model From Database. To make sure you have updated till the last change.
Make sure you are looking at the correct Database and Table. Every one makes this mistake once in a while.
Make sure you are using the valid connection string. Pointing the proper databases. Make sure its not a old db / some other backup db.
Make sure you are using the proper entity which is up to date.

The above code you have, its perfectly working fine to me. I just did a workout to sort out this issue.

The above points are guesses.

Refer this Link Entity Data Model Example & One More Example Code available here

edited Nov 07 '14 at 12:05

answered Nov 07 '14 at 11:17

RajeshKdev

6,365
6
58
80

I cant find AddObject() – Syed Salman Raza Zaidi Nov 07 '14 at 11:18
Still not getting the InsertonSubmit() – Syed Salman Raza Zaidi Nov 07 '14 at 11:22

score 0 · Answer 2 · edited May 23 '17 at 10:25

0

I had a similar problem once and it can be a pain to determine what exactly causes this. One issue that might be causing such a behavior in EF is having multiple instances of the Context object such that when you call SaveChanges on your Context, you are actually calling it on a different instance than the one you added the entity on (and EF does not detect any changes in the entities or the new entity is not attached to the right context, causing SaveChanges to not send any SQL requests to the database).

I suggest debugging this in VS (using the object id feature) in order to see if you have multiple context instances. Using the Unit Of Work pattern together with repositories is a way to have a better control over the lifetime of the context objects in your application

edited May 23 '17 at 10:25

Community

1
1

answered Nov 07 '14 at 12:58

barca_d

1,031
2
13
30

Thanks,How can I debug using the object id feature? – Syed Salman Raza Zaidi Nov 07 '14 at 13:23
http://stackoverflow.com/questions/4251450/uniquely-identifying-reference-types-in-the-debugger If you have different instances, you will have different ID's in the watch bar of VS – barca_d Nov 07 '14 at 13:34

Entity Framework Save not working

2 Answers2