Recall that LINQ based object relational mappers (ORM) use expression trees to effectively translate your C# (or other language) LINQ code into SQL. Many DBA’s and developers that don’t fully understand this technology are often quick to discredit it. I’m…
Blog Archives
LINQ to SQL & Entity Framework Pitfalls
In my last post describing the differences between LINQ to objects and LINQ to SQL, I mentioned how LINQ to SQL and Entity Framework “interpret” your LINQ code, and create the corresponding SQL. Forgetting this fact is extremely dangerous, because…
Understanding LINQ and LINQ to SQL (and EF)
Back to basics for this post. Developers often throw around the word LINQ when talking about a number of different technologies. Now that I have been comfortably using a wide variety of LINQ technologies for a fair amount of time,…
Determine if a point is contained within a polygon
One of my recent projects had a requirement to take a list of points and a list of polygons (of any order), and determine which points were in which polygons. I find this problem interesting, because the solution is not…
Value type comparison pitfall with == vs Equals
I recently ran into a situation that momentarily confused me, because it was non-intuitive to me at first. I’m working on a class that tracks changes made in UI controls in Silverlight, and I wrote code similar to the following:…
Using C# Yield for Readability and Performance
I must have read about "yield" a dozen times. Only recently have I began to understand what it does, and the real power that comes along with it. I’m going to show you some examples of where it can make…
Locking sessions for multi-threaded access
I recently ran into a situation where I needed to upload some small files from a Flex client application to an ASP.NET web server. I decided to store the uploaded files in the users session while they were in the…
Using objects or repository interface in constructor
I’ve been really trying to use the Single Responsibility Pattern in all of the classes I design. Recently, I needed to create code to query a list of holidays from the database, and then create a method that allows you…
Using “var” to simplify code and avoid redundancy
You’ve probably already heard of the new "var" keyword that you can use to declare variables in your .NET code. I wanted to clear up some quick myths and give a quick overview of when it’s most valuable. If you…
A Dependency Injection example with Spring.NET
As requested, here is a real world example of how I used dependency injection to simplify a project, increase modularity, and subsequently increase testability. Here’s the project. I have a successful website called SimpleTracking.com which allows you to track packages…
