CODEWITHSUNDEEP
c#databaseentity-frameworkinsertsql-update
ZeroVirus999
ZeroVirus999

Reputation: 1

Unable to save data to Entity Model Database using saveChanges() method

I am trying to save data to my database. What I want is that when the button is pressed, data is saved to the database permanently. I've done tests where code is saved while the application is running. The saved data is viewable. But when I terminate the application, the data is not present when I view the data for that table in visual studio. I've provided the code that I am using for testing. 

private void btn_otrFun_Click(object sender, EventArgs e)
    {
        tblCheese cheese = new tblCheese();
        string cheesename = "TestCheese";
        cheese.CheeseName = cheesename;
        cheese.CheeseGroup = 1;
        cheeseEntity.tblCheese.AddObject(cheese);
        cheeseEntity.SaveChanges();
    }

Here is where I am getting the context form. It is instantiated at the beginnning of the form.

 private CheeseWorld_DatabaseEntities cheeseEntity = new CheeseWorld_DatabaseEntities(); //instanciate new database entities

And further I am using this snippet to retrieve data from the the database to dynamically created buttons.

var cheeselist = cheeseEntity.ExecuteStoreQuery<tblCheese>("Select * FROM tblCheese WHERE cheeseGroup = 1", null).ToList();

Hope these further details help. If more are required, let me know.

Upvotes: 0

Views: 1163

Answers (1)

Jasmine
Jasmine

Reputation: 4029

You've departed from the normal pattern we usually use for this... maybe try putting it back to something like this... (I don't see where you are getting the context)

using (var context = new cheeseEntity()) {
    tblCheese cheese = new tblCheese();
    cheese.CheeseName = "TestCheese";
    cheese.CheeseGroup = 1;
    context.tblCheese.Add(cheese);
    context.SaveChanges();
}

This is covered in the documentation: http://msdn.microsoft.com/en-us/data/jj593489 (Pay attention to the bottom where it shows how to trace the generated SQL)

NOTE: I am using Add instead of AddObject.

Upvotes: 1

Related Questions