Quick LINQ question

I'm throwing this out there hoping there's a LINQ guru lurking among my readership somewhere.

I'm trying to add a Row Number Column to a LINQ query. In fact, this looks to be exactly what I want to do, however his example won't compile for me - "An expression tree may not contain an assignment operator".

I'm hoping there's something simple and obvious I've missed. My code looks something like:

int i = 1;

args.Result = from userimage in db.UserImages
              where userimage.UserID == userGuid.Value
              select new
              {
                  userimage.ImageID,
                  Name = userimage.Image.ImageName,
                  rowId = i++
              };

ImageID is a Guid in this case, otherwise I could probably make do with that.

Tags:

 Print | Posted on Monday, June 09, 2008 11:25 PM |


Feedback

Gravatar

# re: Quick LINQ question

Tried it out and the basic syntax seems fine.

It could be the args.Result =, as it depends on what type "Result".
You might new a DefaultOrSingle to only return one object to "Result".

6/12/2008 2:38 AM | Blair

Gravatar

# re: Quick LINQ question

Cheers for testing that out :)

The code is running inside the Selecting event of a LINQDataSource, so it's definately expecting multiple results - plus the code runs fine returning multiple results if I take the attempted rowId code out. I also tried not using the args.Result, and just throwing the results into a var and it still doesn't compile.

Hmm although as I type this I have another idea.. investigation required ;)

6/12/2008 8:41 AM | Ross Hawkins

Post Comment

Title  
Name  
Email
Website / Url
 

Your comment

   
Please add 8 and 6 and type the answer here:

About me

My name is Ross Hawkins and I'm a Developer, Consultant and Writer based in Auckland, New Zealand. My current work revolves around ASP.NET, C#, Ajax, SQL Server, and a mix of other Microsoft development technologies. Previously I spent about 11 years working with Lotus Notes/Domino.


Subscribe

Subscribe to this feed


Search


Popular Content

Troubleshooting WebResource.axd

The .NET 2.0 framework changed the way clientside JavaScript is delivered to the browser. Previously, ASP.NET 1.1 used the aspnet_client directory whereas now 2.0 uses WebResource.axd.

Published on October 8, 2006

Microsoft AJAX Extensions: Sys.Debug is null or not an object

One of the breaking changes which was made with the 1.0 release of the Microsoft Ajax Extensions was the renaming of the 'Debug' class to 'Sys.Debug' for reasons of compatiability with other frameworks. Breaking changes like this can often be a source of frustration..

Published on May 22, 2007

Simple ASP.NET Character Counter

A textbox character counter is a pretty simple piece of functionality, and there's a lot of different ways to apply one to your application. The following method is nice and simple, and can be done using only clientside JavaScript if required, or combined with server side code in order to create a more dynamic effect

Published on December 4, 2006

Adding Tooltips to Gridview Headers

As the title says, this is a very simple but dynamic way of achieving tooltip text on a header column. It's not overly flash, but it's lightweight and quick to implement.

Published on April 15, 2007

SQL Server Web Report Viewer Issues on Windows 2008 Server/IIS7

A fix for another AXD related issue, this time with the SQL Server Web Report Viewer Control which was being served up via IIS7 on a Windows 2008 server.

Published on June 2, 2007
Updated on April 10, 2008


Archives

January, 2009 (2)
December, 2008 (6)
November, 2008 (7)
October, 2008 (9)
September, 2008 (12)
August, 2008 (9)
July, 2008 (6)
June, 2008 (24)
May, 2008 (13)
April, 2008 (16)
March, 2008 (8)
February, 2008 (10)
January, 2008 (1)
December, 2007 (14)
November, 2007 (11)
October, 2007 (11)
September, 2007 (13)
August, 2007 (11)
July, 2007 (5)
June, 2007 (15)
May, 2007 (11)
April, 2007 (9)
March, 2007 (9)
February, 2007 (10)
January, 2007 (8)
December, 2006 (18)
November, 2006 (11)
October, 2006 (14)
September, 2006 (9)
August, 2006 (10)
July, 2006 (4)
June, 2006 (4)
May, 2006 (6)
April, 2006 (3)
February, 2006 (6)
January, 2006 (10)
September, 2005 (2)
August, 2005 (4)

Post Categories

ASP.NET
AJAX
Amusing
NZ
NZ Trains
Notes/Domino
Visual Studio
Web Development
Miscellaneous
Me
Rugby
C#
SQL


Twitter