Technology Related Links for May 13th

If you are looking to follow this series, be sure to subscribe to my RSS feed at http://feeds.jasongaylord.com/JasonNGaylord or my Twitter account at http://twitter.com/jgaylord. This series can be followed by using the Hot Links tag. Series Post #12 The asp.netPRO 2009 Readers’ Choice Award Winners haveen been announced. Daily Quote – "$(document).ready() is the new Page_Load" (Posted by Scott Koon) .NET Languages – C# and Visual Basic ARCast.TV – Kevin Hazzard on Dynamic Languages – G. Andrew Duthie Sneak Preview: Persistence Ignorance and POCO in Entity Framework 4.0 – ADO.NET Team The Road to 4 – WCF Changes between Beta … Continue reading Technology Related Links for May 13th

Installing Team Foundation Server 2008 on SQL Server 2008

One of the prerequisites for TFS 2008 is that it must be installed to work with SQL Server 2005 SP2 or SQL Server 2008. However, TFS 2008, by itself, will not work with SQL Server 2008. You’ll receive an error message that your SQL Server instance is not compatible as I’ve mentioned at http://tinyurl.com/4shjod. You’ll receive other error messages such as Full Text not being installed. After struggling for a couple of days, I decided to ask one of my local TFS guru’s, Steve Andrews. He pointed me to an article that led me to Abdelhamid’s blog post at http://blogs.msdn.com/aabdou/archive/2008/05/13/team-foundation-server-sp1-beta-now-available.aspx. … Continue reading Installing Team Foundation Server 2008 on SQL Server 2008

Use LINQ to XML to Generate Excel Documents

I was looking for a quick and easy solution to export data from SQL into an Excel format from within my ASP.NET application. I came across a great video posted by Beth Massi on the asp.net website (Video #7 at the bottom at http://www.asp.net/learn/linq-videos/). Beth steps through creating the LINQ to XML and how you can populate your Excel document. When I used this in an ASP.NET application, I added the XML declaration to the Response.Write so that Excel could understand the document. In ASP.NET, the XMLDocument type has a tendency to drop the XML declaration when writing out the … Continue reading Use LINQ to XML to Generate Excel Documents

Microsoft Releases SQL Server 2008

SQL Server 2008 has been released to manufacturing (RTM’d) today. For more information about this release, be sure to visit Microsoft’s press release at http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx.

Using the LINQ Keyword "First"

All day I was stumped on why there wasn’t a simple way to grab the first object in a sequence other than using: .Take(1).Single Then I discovered the keyword First. I’m still a little puzzled as to why .Single would throw an exception if more than a single element would be returned. I can’t really see a practical use for it unless you wanted to force only 1 object being returned.

LINQ to SQL and MS Small Business Server 2008 Talks at .NET Valley

The next .NET Valley User Group event will be on June 18th at Scranton University in Scranton, Pennsylvania. There will be two talks that evening. The first will begin at 6pm and will be presented by Michael Murphy. Michael will talk about the ins and outs of Microsoft Small Business Server 2008. The second talk will begin at 7:15pm or so and will be presented by yours truly. I will be talking about LINQ to SQL. To register for the event, please visit http://dotnetvalley.com/events/eventdetails.aspx?eventid=59.

Performance Tip: Return Only Necessary Columns Using LINQ

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 … Continue reading Performance Tip: Return Only Necessary Columns Using LINQ

Retrieving SQL Type Image Using LINQ

LINQ views the Image type in SQL Server as Binary. So, there are a few options that we have. We can either (a) modify our LINQ to SQL class and change the property to Byte() instead of Binary or we can (b) convert the Binary to an array. To do the latter, you can use a lambda expression to obtain the image you are looking for and grabbing just the image. Here’s an example: MySqlContext.Photos.Single(Function(p) p.PhotoID = PhotoID).OriginalBytes.ToArray The above assumes that we have a table called Photos that contains a column called PhotoID. We’ll filter the PhotoID (p.PhotoID) based … Continue reading Retrieving SQL Type Image Using LINQ

SQL Management Studio Shows All Databases

This has "bugged" me for awhile. When you log into any version of SQL (2000, 2005, and even 2008) as a user with restricted access to just a single database (or even a few databases), you can still see a complete list of all the databases on that server. There have been times when I needed to share a database with a customer or have accessed a shared database at a host such as DiscountASP.net or GoDaddy and can see all of the customers on that one box. It’s more of a nuisance than a real threat but I really … Continue reading SQL Management Studio Shows All Databases