Jason N. Gaylord's Blog : LINQ

Technology Related Links for May 6th, 2009

Jason N. Gaylord's Blog — Thu, 07 May 2009 03:37:39 GMT

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 #7...(read more)

Technology Related Links for May 4th, 2009

Jason N. Gaylord's Blog — Mon, 04 May 2009 20:49:49 GMT

Summary of the MSDN Freedom Roadshow

Jason N. Gaylord's Blog — Mon, 17 Nov 2008 21:10:26 GMT

For those not at the MSDN Freedom Roadshow in Scranton, PA today, you are missed a good show. Here’s what happened: David Solivan – David presented a talk called UI, UX, U confused? The purpose was to show the various options we have and to explain when...(read more)

Use LINQ to XML to Generate Excel Documents

Jason N. Gaylord's Blog — Mon, 11 Aug 2008 19:01:25 GMT

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...(read more)

Using the LINQ Keyword "First"

Jason N. Gaylord's Blog — Tue, 08 Jul 2008 18:42:51 GMT

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...(read more)

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

Jason N. Gaylord's Blog — Fri, 13 Jun 2008 17:20:57 GMT

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...(read more)

Performance Tip: Return Only Necessary Columns Using LINQ

Jason N. Gaylord's Blog — Wed, 11 Jun 2008 02:30:37 GMT

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...(read more)

A circular reference was detected while serializing an object of type 'XXX'

Jason N. Gaylord's Blog — Mon, 09 Jun 2008 20:43:58 GMT

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...(read more)

Retrieving SQL Type Image Using LINQ

Jason N. Gaylord's Blog — Wed, 28 May 2008 03:23:33 GMT

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...(read more)

Using "Like" in LINQ to SQL

Jason N. Gaylord's Blog — Wed, 21 May 2008 15:37:02 GMT

I've recently discovered that LINQ and VB can be confusing. I was attempting to pull the top 10 rows of a table where the column started with 'W'. You'd think after I typed that, I'd figure out the solution. That's not the case...(read more)

Using LINQ to SQL and ConnectionStrings in a Class Library

Jason N. Gaylord's Blog — Tue, 20 May 2008 18:22:49 GMT

I was looking to separate my LINQ to SQL data layer from the rest of my application. So, I decided to move the files to a class library. This way, when my application builds, all of my LINQ files are found in MyApp.DL or something similar. However, I...(read more)

Obtain the Identity of a New Row Using LINQ

Jason N. Gaylord's Blog — Tue, 20 May 2008 18:05:31 GMT

It's actually pretty easy and user friendly to obtain the value of the identity column using LINQ. After you create your object and insert it on submit, you can call the identity column's property on your object. For instance: Dim db As New BlogDataContext...(read more)

Aggregate Functions in LINQ

Jason N. Gaylord's Blog — Thu, 01 May 2008 15:17:17 GMT

I found a great post which summarizes aggregate functions in LINQ. It includes examples for Average, Sum, and Count. Check it out at http://www.dev102.com/2008/04/16/how-to-use-aggregate-functions-with-linq-to-sql/ . As always, you can test your functions...(read more)