Browse by Tags

All Tags » Databases (RSS)

Issue with ADO.NET Sync Services and SQL Server 2000 by Jason N. Gaylord

Last Friday I had a battle and won. I was working in VS 2010 on an internal project that was being targeted for .NET 3.5. Everything was going good until I decided to be fancy. The application pulled down several tables that contain mostly static stuff...

Installing Team Foundation Server 2008 on SQL Server 2008 by Jason N. Gaylord

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...
Filed under: ,

Use LINQ to XML to Generate Excel Documents by Jason N. Gaylord

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...

Microsoft Releases SQL Server 2008 by Jason N. Gaylord

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 .
Filed under:

Using the LINQ Keyword "First" by Jason N. Gaylord

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...
Filed under: ,

LINQ to SQL and MS Small Business Server 2008 Talks at .NET Valley by Jason N. Gaylord

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...

Performance Tip: Return Only Necessary Columns Using LINQ by Jason N. Gaylord

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...

A circular reference was detected while serializing an object of type 'XXX' by Jason N. Gaylord

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 ....

Retrieving SQL Type Image Using LINQ by Jason N. Gaylord

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...

SQL Management Studio Shows All Databases by Jason N. Gaylord

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...
Filed under:
More Posts Next page »