Here's the Linq to Sql causing the error to be thrown.
var results = db.Entries
.Where(m =>
m.Category.Group.ContestID == contestId && m.CategoryID == categoryId)
.Select(m => new { CategoryName = m.Category.Name,
BusinessName = m.Business.Name,
Count = m.Votes.Count(),
Street = m.Business.Locations.Address
})
.OrderBy(m => m.Count);
The generated sql throws an error.
I really prefer using a service oriented architecture whenever possible and find it particularly useful when I'm developing an internet application because it allows for a much looser coupling between the user interface layer and the rest of the application.
- Zune Desktop App Upgrade: Fix the "No Zune connected" Problem.
- Zune Desktop App Upgrade: Redesign the UI for the Zune Software to use standard widgets we all know and love. Its incredibly hard to use because the visual cues we're used to don't exist.
- Zune Firmware Update: Add a new feature to the zune. If I'm listening to a song on my zune, let me tap the
button and option to listen to other songs from the album and other songs by the same artist.
"No Zune Connected" Problem
Problem
Did you buy a zune and see that it is recognized in Device Manager (with an exclamation point), but the zune software says "No Zune Connected" no matter what you try? The microsoft article's no help in this case, but here is how to fix your Zune's connection problem.
Here's some handy, non-regex based SQL that will replace all non-alphanumeric, all non-whitespace characters in a given column. Read More
I ran into an issue trying to migrate an existing WordPress blog from WordPress to WordPress MU. It seems that with WordPress MU's import, it will import everything directly into the default blog which I didn't want in this case. I needed to import it into a specific blog. This is actually pretty easy to do.
So, I was writing a generic "framework" css file at work and there were a couple of things that just REQUIRED me to pick a color. Now, far be it from me to try and design anything...so I just went with black and white and made a note to over-ride them so I wouldn't forget.
Here a couple of free tools to use for UML/ER diagramming if your company can't afford to buy a commericial package. If you know of anything better, please post it below.
Have you ever ran into a situation where your designer.cs file was broken, missing, or was incorrectly generated by Visual Studio? If you have, you probably know how painful it is to recreate this file by hand. There's a better way though. Here's how to force Visual Studio 2008 to regenerate your Designer.cs file. Read More