Background I use ArrayList heavily to load datasets into memory to minimize database queries. This creates huge performance increases, especially for retail oriented sites with lots of product browsing. I had implemented sorting and searching prior to LINQ but doing this involved somewhat archaic means (IComparer, and foreach loops) I knew there had to a better way to filter an ArrayList than using a foreach loop so I looked into the LINQ functionality. I found this MSDN article that explained most of what I wanted. I also wanted to put the data back into an ArrayList so I had to...
Background
Ecometry is the order managment system we use at Velowear.com (one of my responsibilities as Voler's IT Manager). Ecometry has many features for locating duplicates; but it does not include the ability to search through the entire customer data-set to find possible duplicates. Given this limitation I was assigned the task to find/merge duplicates using a third party tool (I was working for Velowear as a consultant at this time).
Details
I could not locate a third party tool so I decided to create my own system. Step one was to generate a view in SQL Server that would perform the heavy...