I can't save data using Entity Framework

Asked Nov 14 '12 at 15:24

Active Nov 14 '12 at 16:29

Viewed 781 times

I use this code to add one item to a SpareParts table in my database.

try
{
    Database1Entities _db = new Database1Entities();

    SparePart sparePart = new SparePart();
    sparePart.manufactureID = 2;
    sparePart.name = "detail";

    _db.SpareParts.AddObject(sparePart);

    int changesNumber = _db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);

    int count = _db.SpareParts.Count();
    int i = 8 + 1;
}
catch (Exception e)
{
    Console.WriteLine(e.Message);
}

I tried _db.SaveChanges(). That didn't help.

I don't get any exceptions. And if I start debug 4 times, I will see count = 4. And I can iterate through all my items. But if I wait 1 minute and start debugging one more time, I see count = 1. So it seems that my changes are still not in database.

edited Nov 14 '12 at 16:29

marc_s

732,580
175
1,330
1,459

asked Nov 14 '12 at 15:24

Pelegrim

1

have you tried stepping thru w/ a debugger – Daniel A. White Nov 14 '12 at 15:26
1

start sql profiler and see if any insert statement is coming. – Giedrius Nov 14 '12 at 15:27
of course, and count = 4 after 4 times of starting debugging with 5 second time interval between debugging – Pelegrim Nov 14 '12 at 15:27
Giedrius, how to start sql profiler – Pelegrim Nov 14 '12 at 15:28
Have you read this SO article? http://stackoverflow.com/questions/3920111/entity-framework-4-addobject-vs-attach – Joel Etherton Nov 14 '12 at 15:29
I didn't find help in this article – Pelegrim Nov 14 '12 at 15:35
And you're not doing *anything* different between the 4th and 5th run through? No cleaning and/or rebuilding? – Nick Spreitzer Nov 14 '12 at 16:23
Are you sure something else isn't editing the database? Have you tried just watching the data in there directly (such as via repeated Select statements)? – Bobson Nov 14 '12 at 16:27
Can you show us your **connection string**? – marc_s Nov 14 '12 at 16:29
First, I do this in console application. Connection string is Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True – Pelegrim Nov 14 '12 at 18:04
Refer to the answer (http://stackoverflow.com/a/13385632/266474) I just gave you on your other SO question. – Salvador Sarpi Nov 14 '12 at 19:19
possible duplicate of [How to add entity-framework to console application (images are included)](http://stackoverflow.com/questions/13385013/how-to-add-entity-framework-to-console-application-images-are-included) – cadrell0 Nov 14 '12 at 20:39

I can't save data using Entity Framework

0 Answers0

Linked