Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - [LINQ TO SQL] Probleme for update a child element

Reply
 
Old 06-04-2009   #1 (permalink)
Le_Phasme


 
 

[LINQ TO SQL] Probleme for update a child element

(sorry for my english i'm french) :

3 tables:
[APT]
#AptId as integer
AptRef as Integer
NbPeople as integer

[APTREF]
#AptRef as integer
AptId as integer

[Request]
#RequestId as integer
RequestAptRef as integer

A relation is here : [Apt].AptRef <=> [AptRef].Aptid

Problem :

In my code :
MyRequest = (from MesRequest in dtct.Request _
where MesRequest.id=1 _
select MesRequest).single
For default, linq provided me MyRequest.AptRef as AptRef
When i want to update this :
MyRequest.RequestAptRef=Value (integer)
or MyRequest.AptRef= (from MesAptRef in dtct.aptref where MesAptRef.aptid=1
select MesAptRef).single
Error message ...

How to update this element?





My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
getting cr/lf out of xml with linq to xml? .NET General
Linq To Sql using store proc is calling update instead of delete .NET General
Linq to SQL .NET General
LinQ. update column with auto generated value .NET General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46