WebLog of Ken Cox - All Comments

re: Visual Studio 2008 SP1 Adds JavaScript Formatting

Melwin — Sun, 08 Nov 2009 07:49:20 GMT

Javascript formatting was driving me crazy, until I did some search and found this post. Thanks a lot!

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

squorpeeon — Sat, 31 Oct 2009 15:01:04 GMT

At least you didn't called a "dumb**s".

Thanks for the quick fix.

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

purs — Thu, 22 Oct 2009 05:25:13 GMT

Thank you :) the post really helped me to figure out the error quickly.

re: VS 2010 Product Release Date? March 22, 2010

Fabiano — Wed, 21 Oct 2009 19:42:28 GMT

Nice post. I just noticed TFS Beta 2 doesn't support Windows 2003 64-bit edition. I am wondering whether the final TFS release will support it or not...

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

Kevin Haesendonckx — Thu, 15 Oct 2009 11:30:14 GMT

Thanks man, this helped me a lot, keep up the good work

re: Windows 7 Ultimate Signature Edition w/ Party Pack

Ken Cox [MVP] — Wed, 14 Oct 2009 23:02:10 GMT

@Joseph: It's odd that MS hasn't taken action. Recall that Microsoft was pretty quick to sic the lawyers on Canadian highschool student Mike Rowe for daring to use his name in a domain name called MikeRoweSoft.com.

re: Windows 7 Ultimate Signature Edition w/ Party Pack

Joseph Sherbaugh — Wed, 14 Oct 2009 22:23:05 GMT

Yes , I know I even called Microsoft to report it and the said you can not sell those copies!! People just do not think before they act.

re: Animation on MSDN Web Pages? No Thanks

Jeff — Wed, 14 Oct 2009 16:01:33 GMT

That animation is particularly not useful because you can't read it in the time it sits between changes.

re: Animation on MSDN Web Pages? No Thanks

Rob — Wed, 14 Oct 2009 08:08:36 GMT

If anything the animation is a minor concern. Granted it's a pain, but the bigger problem is the advertising.

If this is a site that is supposed to enable developers, don't advertise 3rd party apps to/at them, give them the info they need, don't distract them.

re: Converting VB LINQ to C# LINQ

Michael Fielding — Thu, 08 Oct 2009 14:05:17 GMT

I tried using the program to convert the following LINQ query to C#:

Dim qry = From d In _rawData _

Order By d.FormatName, d.QualityName _

Group d By d.FormatName, d.QualityName _

Into MyAvg = Average(d.GrossWeeklyPanelRate), MyCount = Count(d.GrossWeeklyPanelRate), _

MyMin = Min(d.GrossWeeklyPanelRate), MyMax = Max(d.GrossWeeklyPanelRate)

Which resulted in:

var qry = from d in _rawData

orderby d.Format, d.Quality

group d by new

{

d.Format,

d.Quality

}

into g

let FormatName = g.Key.Format

let QualityName = g.Key.Quality

let MyAvg = g.Average(d.GrossWeeklyPanelRate)

let MyCount = g.Count(d.GrossWeeklyPanelRate)

let MyMin = g.Min((d.GrossWeeklyPanelRate)

let MyMax = g.Max(d.GrossWeeklyPanelRate)

select new { FormatName, QualityName, MyAvg, MyCount, MyMin, MyMax };

However, I get an error in the aggregate function: The name 'd' does not exist in the current context. How am I to get the average, count, minimum and maximum of a field with my data?