Was trying to write very simple Linq statement today (below) and I received the following error Linq Statement Error Message Received "LINQ to Entities does not recognize the method 'System.Guid get_Item(Int32)' method, and this method cannot be translated into a store expression."...
Today I needed to load in an XML file into memory for later use. At first I was going to use the XmlDocument library (old habits die hard), but later switched over to the XDocument library. Why, not because one is better (ok, so I think that XDocument is better, but not the point here), but because...
For the first time in a long time I needed to update values inside an XML document. I have done this type of action many times in the past and have always hated it. The syntax is clunky and the process is simply painful. So today when I realized I need to do this, let me just tell you I was...
Today as I was diving further into my Linq2Sql Odyssey I ran into a need to do grouping on data. Bud not just single column grouping, I needed to group by multiple columns from multiple tables. Because it took me a few minutes to get right, I thought I would share my experiences. Imagine...
***** Disclaimer ****** I may be the last person to figure this out, but oh well. ***** End Disclaimer ****** Today as I was further exploring the coolness that is Linq to Sql I ran into a little situation. I was creating a query where I wanted to use the columns form multiple tables to build an...