Any WCF/LINQ experts out there? I'm having a heck of a time getting my relational data to pass through WCF.
First off, I tried all of this through straight LINQ to SQL and was getting some error regarding a circular reference, which I found puzzling as I didn't see a circular reference in my db. After fighting with LINQ to SQL I moved on to trying PLINQO and the circular error went away, however the nested Lists of entities won't transmit properly.
I have several tables in my db but the 2 currently in question are CustomersVendors and Addresses. The addresses are linked to the CustomersVendors table via listID <--- customerVendorListID and the 2 columns are identical. When I request a CustomerVendor by listID I expect to get back all of their details including a List(Of Addresses). Upon tracing the results I see the query works just fine and I do in fact see the Addresses in the CustomersVendors entity. The problem is, once this data is sent out via WCF the Addresses entity inside of the CustomerVendor is NULL. Tracelogs on the server side of my app don't show the addresses so they are obviously never leaving the server. I'm guessing it's a serialization issue but I'm at the end of my rope trying to find the cause. I sure hope someone out there can figure this one out.
vs2008 SP1 (VB.NET)
.NET 3.5 SP1
Vista Business SP3