context.SaveChanges() not persisting data in database

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hello, Im working on a MVC app.

When I call context.SaveChanges to update a specific records. The update is not registered in the database. I do not get any runtime error either. All in notice is that my Records is not updated. I still see the same values. Insert Functionality work Perfectly.

What seems to be the problem?

here is my code

public Admission Update(int stuid)
{
VDData.VidyaDaanEntities context = new VDData.VidyaDaanEntities();
VDData.Student_Master studentmaster = new VDData.Student_Master();

studentmaster.Student_ID = stuid; //here i will get the ID.
studentmaster.Student_First_Name = this.FirstName;
studentmaster.Student_Middle_Name = this.MiddleName;
studentmaster.Student_Last_Name = this.LastName;
studentmaster.Student_Address_1 = this.Address;
studentmaster.Student_Address_2 = this.Address2;
studentmaster.Student_City = this.City;
studentmaster.Student_State = this.State;
studentmaster.Student_Pin_Code = this.Pincode;

context.SaveChanges(); // here it wont give any kind of error. it runs sucessfuly.
}

Posted 14-May-13 1:29am

harshal7689

Updated 14-May-13 19:15pm

v3

Add a Solution

Comments

ZurdoDev 14-May-13 7:31am

You'll need to do a trace, either SQL profiler or debug your code, or both.

Yuriy Loginov 14-May-13 9:27am

try
context.Table.State = EntityState.Modified;
context.SaveChanges();

harshal7689 15-May-13 1:56am

i trying ur code but it give me error at "State". for that can i need to add any reference into my code

Mohammed Hameed 15-May-13 1:21am

Debug & verify all the values at runtime.

harshal7689 15-May-13 1:55am

i already done the debugging as well as verify the values but the table not getting update.

4 solutions

Solution 1

Hello,

Please read this articles:
http://msdn.microsoft.com/en-us/library/bb896271.aspx[^]
http://stackoverflow.com/questions/8056761/context-savechanges-not-working[^]

Your object is probably detached from the context object.

Bye.

Posted 14-May-13 2:54am

José Amílcar Casimiro

Solution 4

Thank guys to help me and i am happy that my code is working Properly
i did a some changes and my code works perfectly.

Old code:

VDData.Student_Master studentmaster = new VDData.Student_Master();

New Code:

Student_Master studentmaster = context.Student_Master.Single(p => p.Student_ID == stuid);

due to above line my Records updated into table.

Posted 14-May-13 20:45pm

harshal7689

Comments

Zoltán Zörgő 15-May-13 3:40am

Feel free to accept all the answers that helped you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-05-14T19:54:00

Be aware, that you can create an object of a type in your model, without adding it to the data store. And you are actually doing this.
In the model you have a collection of VDData.Student_Master. It should be context.Student_Masters - but it depends on the naming convention you have used. This collection represents the table. You have to add the object to the collection if you want to persist it. And if you want to update an existing one, you have to get it from the collection with Linq to EF's. Just by setting the id of the object won't change it in the data store, even less if it is outside the collection.

See: http://www.dotnetcurry.com/ShowArticle.aspx?ID=619[^]
And this has nothing to do with MVC.

TanvirRaihan · Accepted Answer · 2013-05-14T20:03:00

Hi
I think in case of update you should read the student master first rather than creating a new object.

so you should not do the following:

VDData.Student_Master studentmaster = new VDData.Student_Master();

Rather you should read it first from context like:

VDData.Student_Master studentmaster = Read from context using Student_ID ;

rest of your code may remain same.

Hope this will help you.

context.SaveChanges() not persisting data in database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0