Building Performant Line of Business Applications with LINQ to SQL

The Scenario Throughout the article, I will refer to the AdventureWorks database and use the following hypothetical customer scenarios: Customer browses list of all products Customer checks status of order through web portal showing all previous orders; detail for first order shown Each step in the scenario requires different entities in different configurations; to keep…


Building Line of Business Applications with LINQ to SQL

Introduction The LINQ framework offers a basic pattern of sequence operators, allowing for primitive behavior such as filtering, grouping, and joining over collections and types. The support of the high level query comprehension syntax in C# 3.0 is paramount to developing an application quickly and allows for transparent development practices for developers where querying an…


Influencing Executives

Preparing Your Idea The first real step in preparing a proposal with a greater chance of success is finding a subject you’re passionate about. Even if you present all the data to support your idea, your lack of passion for the subject will give you the disadvantage when asking an executive to take a risk…


Easy String to Resource file refactoring

During the development of internal tools we often have to stop working on features and clean up after ourselves to ensure that strings and such are embedded in the appropriate resource files and not hard coded into our applications. This can be a very tedious and time consuming process. Luckily there is a refactor extension…

1

Utilizing memoization and Dijkstra’s Fibonacci algorithm to compute large values

More of an acute fascination than anything else I expanded my use of memoization for computation to use a more efficient means of calculating Fibonacci sequences for values of n greater than 40 (previous Fibonacci example takes several minutes to compute value at 45 and is fairly unusable beyond that). To perform the computing of…


Extensions I found useful while developing with WPF and LINQ to SQL

  When I observe developers writing solutions using LINQ to SQL or Entity Framework, I see a number of conversions occurring time and time again. Below are some of the more trivial utility method extensions I used when developing solutions based on LINQ to SQL and WPF—simple as they are I found them useful in…


Significantly speeding up computations with smart predicates

There is a technique that allows optimization of repeated calculation results for a set of inputs called memoization. This technique is particularly helpful when working with numeric computations, pathing, such as for tree searches, etc. where the time taken to traverse the result set is expediential. What’s more interesting is that the technique is applied…

3

Software development outsourcing and client proximity

I had a recent comment come in that I wanted to share: I was wondering what your take was on Consulting firms. Although it is not offshore outsourcing, in some sense, it is still outsourcing their projects to firms. I totally agree with you regarding the lack of communication and planning to execute and deliver…

1

Visual Studio 2008 Released

After months of waiting, I can finally say that Visual Studio 2008 was released last week. There are hundreds of new features, language enhancements, and technology integrations in this version. To help you get your head around what is new in Visual Studio 2008 and .NET Framework 3.5, get the training kit from Microsoft download…


Why moving work offshore fails

Not to say that all offshore projects fail, I have both been a contributor and leader in projects that have been a great success and those that have been complete failures. Each project had its own reasons for failing and were defined by the business (e.g. why are you sending it offshore to begin with) that…

4