Post-talk update
There are two corrections to my talk in the comments. I missed assigning the DataLoadOptions to my DataContext object in my sample code. Also, I said last night that the ConnectionTimeout is assigned to the DataLoadOptions–I totally lost my head on that one. The ConnectionTimeout is a property of the DataContext object. Sorry for any confusion.
I’ll have updated slides and sample posted here shortly (I’ll leave a note when I do), and I’ll send the corrected samples to Dave to be posted at the Pgh .NET site.
Original post…
I’m speaking at the Pittsburgh .NET User Group tomorrow (Oct 14, 2008) on Linq to SQL and Linq to XML.
In the ZIP file is the presentation (PDF), sample XML file and complete source code for my presentation. Unzip the file, and place the XML at c:\xml. Create a sample database using the script in the project, and update the connection string. There are four methods you can call, demonstrating the different techniques I’ll be covering.
Download the presentation and code sample.
Also, in case you haven’t yet voted, please vote for Scrumr. We’re working on this in our spare time, and could use the tools to make better software.
great presentation. really enjoyed.
One thing about DataLoadOptions.LoadWith()…
the instantiated object, should it be assigned to somewhere ? your local variable _options in the code in Module1.vb doesn’t …
here is a snippet from microsoft website, notice the third line:
Dim dlo As DataLoadOptions = New DataLoadOptions()
dlo.LoadWith(Of Customer)(Function(c As Customer) c.Orders)
db.LoadOptions = dlo
Doh! You’re 100% correct Alexis, thanks for catching that. I forgot that last line in my example code. We appreciate you coming last night, and hope you enjoyed the talks.
Also, to make another correction–I said last night that connection timeout is set through the DataLoadOptions, and that’s also wrong. I totally lost my head there. Connection Timeouts, etc. are set directly against the Data Context objects. Doh! again.