A while back, I wrote an application that processes sales information. These sales actually represent a hierarchy of data because there can be refunds, charge backs, charge backs of charge backs, refunds of refunds, adjustments, and so on and so forth. The way the data processing is handled, though, treating the entire hierarchy as a single transaction is important. This requires a bit of recursion.
.NET and SQL Recursion
posted on February 23, 2017 by long2know in ASP.NET, Database, Entity Framework, LINQ
Building LINQ Expressions (Part 2)
posted on October 10, 2016 by long2know in Database, LINQ
Continuing our examination of building LINQ expressions, let’s dive further into generic methods that can build expressions for any enumerable list of objects. In part one, I showed how to build a simple string expression, but we can make this much more robust.
LINQ Outer Joins
posted on September 7, 2016 by long2know in ASP.NET, Database, Entity Framework, LINQ
Using LINQ’s FluentAPI, left/outer joins are difficult. With a little work, it’s possible to perform left outer joins, though.
Complex EF joins and aggregation
posted on August 30, 2016 by long2know in Database, Entity Framework, LINQ
There are a few scenarios, especially when using partitioning/windowing T-SQL functions, that EF falls down a bit. It also is not entirely straight forward to perform somewhat complex joins and aggregation.
Building LINQ Expressions (Part 1)
posted on October 20, 2015 by long2know in LINQ
I’ve said it before, and it bears repeating. LINQ is one of those features in .NET that keeps me using it. In-line queries that allow you to expressively search lists, with the declarative query syntax, is very appealing. Sure, under the covers, it’s performing the heavy lifting, iteration, and such, but the SQL-like lambda expressions are incredibly powerful.
However, sometimes we need something even more dynamic.