Hello, I'm   Jason

I was running into an issue where one of my webmethods was taking a large amount of time to return a small set (5-10 objects). I was using LINQ to SQL. I noticed that the LINQ to SQL query was returning all of the rows. After looking into the table a bit further, I noticed that the table included some columns with a larger type (old text column, image column, etc). So, I decided to modify my select to contain just the columns I needed. It improved my response time from roughly 8 seconds to 250 milliseconds. Here’s a sample select statement:

I ran into an issue earlier when trying to return an entity class through a web service for use in an AJAX page. After some quick research, I came across a post by Darren Neimke that referenced Rick Strahl’s post about LINQ to SQL and Serialization. For me, performing the first work-around and setting the relationship to ‘Friend’ worked.

If you’re looking to pick up the latest happenings from the Worldwide Developer Conference, check out this: http://www.macrumorslive.com/.

I received an email from DirecTV about my blog post on 6/2 (Note: this post is missing from my archives). They gave a 1-800 number and a 4-digit code so I can reach their team directly. I tried using that number and sat in a queue for nearly 20 minutes. Finally, someone answered and had no clue what my situation was. She placed me on hold for 5 minutes to review my account. Once she came back, she told me that I should have never ordered service with only 1 line. After my head spun completely around, I proceeded to ask her how DirecTV was going to fix this issue. She told me that “their” solution would be for me to purchase a Single Wire Multi-Switch (SWM) out of pocket. However, my one receiver wouldn’t work with it so I’d also have to upgrade that receiver to a DVR or HD receiver. In all, I’d be out $400. But, since I was a loyal customer, they’d provide me a $10 credit each month for 6 months. So, I’d still be out $340. I asked her repeatedly if this was what they told other customers and she said they usually don’t provide any credit. At this point I was extremely irate. 20 minutes later she offered a $10 credit each month for 12 months. I asked her to review with her supervisor and come back with her best offer before I switch service and after being on hold for 2 minutes, I was disconnected.

I’ve been using the Ajax Data Controls (ADC) for 9 months. I recently joined their development team to convert the controls to VS 2008/.NET 3.5. It’s a really cool control set that uses AJAX for the complete data transaction. The documentation is pretty deep and there are a few good examples. You should check it out by visiting http://dotnetslackers.com/projects/AjaxDataControls/. You can download the source and binary on CodePlex by visiting http://www.codeplex.com/AjaxDataControls.

Many have found it difficult to establish a VPN connection on Windows Mobile 5. There are quite a few blog posts out there with instructions, but none are really that complete. Before you can establish a connection from your mobile device, you need to establish a VPN server. For my purposes, I’ve setup Routing and Remoting Access on a Windows Server 2003 box (Windows Server 2008 procedure). This is pretty simple to do and there weren’t any settings I needed to modify. Then, on the user account in my domain, I had to right-click and go to properties. There is a section under the Account tab called Account Properties.

The AjaxDataControls that have been developed by the DotNetSlackers team have been out for some time now. They were originally developed using the AJAX 1.0 libraries (pre 3.5 days). I’ve recently encountered some issues where they don’t seem to be playing as nice in VS 2008. So, I’ve updated the dll and made it available for now on my site at http://jasongaylord.com/downloads/ajaxdatacontrols-3.5.zip. As soon as I can get into CodePlex, I’ll upload it there instead.

There is no way to add querystring parameters to the SiteMapNode in a SiteMap control “out of the box.” I’m quite surprised there is no option but luckily the SiteMap uses the provider model. After a Live search, I was able to find a solution provided by Bobby DeRosa. By creating a custom provider, this can be accomplished. The project I was on is an update of an ASP.net app written in VB.net so here is my VB.net port:

We still have Small Business Accounting 2006 implemented for some companies. When we use a custom invoice to print using the MS Word Smart Document set, we receive the error “OLE received a packet with an invalid extension.” This error occurs since the document was created before .NET 2.0 (or 3.0) was installed and before the Smart Document set was installed. To work around this issue, perform the following:

I’ve had DirecTV service for 3 years now. During all 3 years I’ve subscribed to the premium package, the NFL Sunday Ticket, and NHL Center Ice. I have high-definition service with DVR capabilities. So, I pay a decent amount each month to DirecTV. Over the past 3 years I’ve also had my share of customer service “experiences.” When I wanted to upgrade to the HD-DVR receiver, I had to talk to the customer retention department to try to get some money off the receiver. Comcast, at the time, was new to our area and had a great HD/DVR offer for new customers. I finally received some credit for my HD service. When the installer came out, he threw my old dish off my house breaking it into little pieces and leaving a hole in the yard. They also took my old receiver. I called up and complained and all they did was leave the old receiver on the porch.