A field alone does not updating in one entity

Question

0.00/5 (No votes)

See more:

Hi all,

i am using entity framework to access the Db in my project

here i want to update two entity(table) by clicking a update button

VB

Dim xx As entityname = objContext.entityname.Where(Function(c) c.Rowid = intRowId And c.Type = intType).SingleOrDefault
If (true) Then
If Not IsNothing(xx) Then
xx.intrr = xx.intrr + intss
xx.intaa = xx.intaa - intpp
objContext.entityname.ApplyCurrentValues(xx)
objContext.SaveChanges()
End If

Dim yy As entityname1 = objContext.entityname1.Where(Function(d) d.Rowid = intRowId And d.Type = intType).SingleOrDefault

If Not IsNothing(yy) Then
yy.intxx = yy.xx + intyy
yy.inttt = yy.inttt - intss
objContext.entityname1.ApplyCurrentValues(yy)
objContext.SaveChanges()
End If

End If

the above denoting to update two entity in same functionality

here i can able to update the entityname entity
and i also can able to update the entityname 1 entity
but i cannot able to update only one field in entityname1 (for example yy.inttt)

so that i saw the design of the table in the SQL, to check the default binding values
since there is no anyvalue to bind default

what is the mistake done by me
please let me know

Posted 15-Feb-12 1:10am

msk kumar

Updated 15-Feb-12 8:13am

Sander Rossel

v3

Add a Solution

Comments

[no name] 15-Feb-12 11:26am

It isn't very clear. Do you only want the field yy.inttt to be updated, and no other field on this entity?

msk kumar 16-Feb-12 1:54am

Hi Mark
I need to update two entities(tables), enatityname and entityname1 also
ok
in entityname entity
xx.intrr = xx.intrr + intss
xx.intaa = xx.intaa - intpp
this want to update

similarly
in entityname1 entity also want to update the following two fields
yy.intxx = yy.xx + intyy
yy.inttt = yy.inttt - intss
Here the field yy.inttt is only not updating (stay remains the same value in the DB)
but yy.inttxx is updating fine

i think it is clear now
thank you

Kreagan Naicker 15-Feb-12 14:18pm

I'm with Mark on this one, i'm not sure what you require assistance with.

If i literally translation your request, then you only what to update the variable yy.inttt, if this is the case then simply remove the following statement:
yy.intxx = yy.xx + intyy

This should result in only the yy.inttt variable being updated.

1 solution

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)

Not Active · Answer 1 · 2012-02-16T01:16:00

If you want to update the entire object graph then ApplyCurrentValues is not necessary.

http://msdn.microsoft.com/en-us/library/dd487246.aspx[^]
"The ApplyCurrentValues(Of TEntity) method is used to apply changes that were made to objects outside the ObjectContext, such as detached objects that are received by a Web service."

You don't have a detached object.