Click here to Skip to main content
15,121,851 members

Articles by merlin981 (Articles: 10, Technical Blogs: 8)

Articles: 10, Technical Blogs: 8

RSS Feed

Average article rating: 4.35

All Topics
Posted: 2 Oct 2009   Updated: 2 Oct 2009   Views: 14,530   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Thread safe generic queue class
Database Development
SQL Server
Posted: 12 May 2009   Updated: 12 May 2009   Views: 30,374   Rating: 3.86/5    Votes: 5   Popularity: 2.70
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Please Sign up or sign in to vote.
In this article, I will cover how to access data in SQL Server Compact databases (.sdf files) using the new development technologies such as LINQ.
Desktop Programming
Windows Forms
Posted: 16 Aug 2007   Updated: 16 Aug 2007   Views: 66,400   Rating: 2.77/5    Votes: 14   Popularity: 3.17
Licence: Not specified      Bookmarked: 23   Downloaded: 1,231
Please Sign up or sign in to vote.
Using Themer To Skin Forms and Controls
Programming Languages
C#
Posted: 2 Apr 2009   Updated: 2 Apr 2009   Views: 27,001   Rating: 4.50/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 1
Please Sign up or sign in to vote.
In this post, you will learn how to read Twitter feeds with LINQ to XML
Posted: 8 Apr 2009   Updated: 8 Apr 2009   Views: 60,532   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
How to use LINQ GroupBy
Posted: 11 Aug 2009   Updated: 11 Aug 2009   Views: 50,322   Rating: 4.86/5    Votes: 9   Popularity: 4.63
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 0
Please Sign up or sign in to vote.
Thread safe generic Queue class
SQL
Posted: 5 Oct 2009   Updated: 5 Oct 2009   Views: 26,992   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
How to create T-SQL CASE statements with LINQ to SQL
Posted: 1 Oct 2009   Updated: 1 Oct 2009   Views: 14,400   Rating: 3.80/5    Votes: 3   Popularity: 1.81
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Several tips and tricks I have found during my time as a LINQ developer
Posted: 14 May 2009   Updated: 14 May 2009   Views: 16,010   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ
Posted: 1 Sep 2009   Updated: 1 Sep 2009   Views: 11,912   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
Several tips and tricks I have found during my time as a LINQ developer

Average blogs rating: 2.88

All Topics
Posted: 3 Jun 2009   Updated: 3 Jun 2009   Views: 39,231   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: Not specified      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Often we have to get a count of duplicate items in a list. An easy way to do this is to group the list on the property we want to count, then use LINQ's GroupBy's Count feature. Below is a quick example using an employee list.
Posted: 3 Jun 2009   Updated: 3 Jun 2009   Views: 14,801   Rating: 1.20/5    Votes: 2   Popularity: 0.36
Licence: Not specified      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Sometimes you have a list, and you need to return a single element from the list. There are several ways to get the element to return. Below are two ways using LINQ with Lambda expressions.Consider the following class: 1: public class Person 2: { 3: public strin
Posted: 3 Jun 2009   Updated: 3 Jun 2009   Views: 17,950   Rating: 1.00/5    Votes: 3   Popularity: 0.48
Licence: Not specified      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Here's a simple example to show you how to GroupBy Multiple Valuesusing LINQ. In this example, I am grouping by Age and Sex to find thecount of people who have the same age and sex.
Programming Languages
C#
Posted: 19 Apr 2009   Updated: 19 Apr 2009   Views: 355,752   Rating: 2.86/5    Votes: 12   Popularity: 3.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 0
Please Sign up or sign in to vote.
How to use the LINQ GroupBy feature.
Posted: 19 Apr 2009   Updated: 19 Apr 2009   Views: 19,891   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Twitter feeds are provided in RSS XML format. This makes it very easy for us to parse out the information we want from a feed using LINQ to XML.
C++
Posted: 20 Jul 2009   Updated: 20 Jul 2009   Views: 36,770   Rating: 4.17/5    Votes: 4   Popularity: 2.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 0
Please Sign up or sign in to vote.
I know the title is a bit long, but it descriptive of the problem. Recently I had need to retrieve a listing of files and folders given a root path. All worked well, until I tested on Vista and Windows 7 machines.
Visual Basic
Posted: 23 Apr 2009   Updated: 23 Apr 2009   Views: 24,172   Rating: 4.20/5    Votes: 3   Popularity: 2.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
A simple example to show you how to GroupBy Multiple Values using LINQ
WCF
Posted: 20 Jul 2009   Updated: 20 Jul 2009   Views: 39,355   Rating: 2.60/5    Votes: 2   Popularity: 0.78
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
I was recently asked to helpwith a LINQ To SQL query where the resulting T-SQL query was to have CASE statements. Having CASE statements in T-SQL queries is acommon scenario but how do we it in LINQ To SQL?

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

merlin981
Software Developer (Senior)
United States United States
Winner - Best Mobile App - AT&T Developer Summit, Las Vegas, 2013

My personal resume can be found at: http://www.philippiercedeveloper.com

My game portfolio can be found at: http://www.rocketgamesmobile.com

About Philip Pierce:

I am a software developer with twenty years experience in game development, mobile, web, desktop, server, and database. My extensive background highlights an expertise in rapid application development using the latest Microsoft, Mobile, and Game Development technologies, along with the ability to create AI for games and business software, redesign existing software, develop multi-threaded software, and create client/server applications.