October 6, 2008 06:38am pdt

1. Fernando... 87,984
2. naspinski 54,450
3. CarlVerret 17,064
4. sjturner2 14,250
5. Ceiled 12,500
6. TKOTC 7,500
7. CMYScott 5,750
8. TheLearn... 5,172
9. Praesidium 4,664
10. GreenGho... 4,150
11. The_eagle 4,000
11. VBRocks 4,000
13. CodeCruiser 3,400
14. emoreau 3,050
15. gardavis 3,000
15. Dhaest 3,000
17. jaime_oliv... 2,700
18. ZachSmith 2,600
19. boag2000 2,500
19. mark_wills 2,500
21. J_Carter 2,000
21. Smart_Man 2,000
21. SwissKnife 2,000
21. renjurdevan 2,000
21. p_davis 2,000
21. JimFive 2,000
21. graye 2,000
21. IndianOcean 2,000
21. irps20001 2,000
21. Koocurrent 2,000
21. Rahu_ket... 2,000
21. ad5qa 2,000
21. vs1784 2,000
21. dstanley9 2,000
21. burakiewicz 2,000
21. primeMov... 2,000
21. AaronNance 2,000
21. REA_AN... 2,000
21. cottsak 2,000
21. vb_jonas 2,000
21. BondinASP 2,000
21. ajitha75 2,000

1. Fernando... 87,984
2. naspinski 54,450
3. sjturner2 20,250
4. CarlVerret 17,064
5. Ceiled 12,500
6. TKOTC 7,500
7. CMYScott 5,750
8. TheLearn... 5,172
9. Praesidium 4,664
10. GreenGho... 4,150
11. The_eagle 4,000
11. VBRocks 4,000
13. CodeCruiser 3,400
14. emoreau 3,050
15. gardavis 3,000
15. Dhaest 3,000
17. jaime_oliv... 2,700
18. ZachSmith 2,600
19. mark_wills 2,500
19. boag2000 2,500
21. J_Carter 2,000
21. BondinASP 2,000
21. Smart_Man 2,000
21. Rahu_ket... 2,000
21. vb_jonas 2,000
21. vs1784 2,000
21. dstanley9 2,000
21. burakiewicz 2,000
21. primeMov... 2,000
21. JimFive 2,000
21. ad5qa 2,000
21. SwissKnife 2,000
21. SteveH_UK 2,000
21. cottsak 2,000
21. renjurdevan 2,000
21. REA_AN... 2,000
21. Koocurrent 2,000
21. IndianOcean 2,000
21. ajitha75 2,000
21. p_davis 2,000
21. michtsoi 2,000
21. AaronNance 2,000
21. irps20001 2,000
21. graye 2,000

12.29.2007 at 02:29PM PST, ID: 23049249

	[x] Attachment Details

Linq Relationships

Asked by shanewho in Language Integrated Query - LINQ, Microsoft Visual C#.Net, .NET Framework 3.x versions

Tags: .net 3.x

(a link to an image of the class designer and app is below)

I have 2 linq to sql classes, Place and PlaceType. A place is a restaurant and PlaceType is the type of food. To add a new place, you give it a name and select the PlaceType from the combobox (which is bound to a query's results). This works fine when I change an existing PlaceType, but when I try to add a new one with the code below, I get a sql error because it is trying to insert a new PlaceType. Why is it trying to insert a new PlaceType when I only want to insert a new Place and use the existing PlaceType?

See the Image here: http://allyoucanupload.webshots.com/v/2006023520909293090 Start Free Trial

         
             //BusinessLayer.Database.DataContext.Places.InsertOnSubmit(this);  
BusinessLayer.Database.DataContext.Places.Attach(this); 
BusinessLayer.Database.DataContext.SubmitChanges();  //Exception is thrown here

Keywords: Linq Relationships

	Title
1	problem with databound combobox not…
2	Combobox multiple bound columns
3	VB.NET 2.0 ComboBox events - …
4	Error when selecting item in bound Co…
5	Combobox question
6	Populate combobox from dataset

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Linq Relationships

Asked by shanewho in Language Integrated Query - LINQ, Microsoft Visual C#.Net, .NET Framework 3.x versions

Tags: .net 3.x

About this solution