Monthly Archives: September 2007

Linq Tip #2 – Find overlapping date ranges

/** A deceptively ~simple self-join query to find all date ranges in a table that overlap.* A date range is defined by the range between InTime and OutTime.* The "Seq != Seq" filter is required so that each record does … Continue reading

Posted in C# | 9 Comments

Linq Tip #1 – Composable queries

  One of the cooler things about Linq (if it wasn’t already cool enough) is that queriesare composable.  This comes in real handy when you want to dynamically add "where"statements to a query based on some runtime criteria. Data: var … Continue reading

Posted in Uncategorized | 21 Comments