Monthly Archives: December 2017

Archive of posts published in the specified Month

Proxy handling casting in C#

Let’s start with the following code: public interface IHaveASandwich { void Foo(); } public class ASandwichProvider : IHaveASandwich { public void Foo() { Console.WriteLine(“ASandwichProvider — Foo”); } public void Bar() { Console.WriteLine(“ASandwichProvider — Bar”); } } public class Service { public void DoSomethingWithSandwich(IHaveASandwich…

Executing SQL query inside Excel spreadsheet

Did you know that you can execute almost any SQL query directly in your Excel spreadsheet? This can be very useful for executing queries with GROUP BY and aggregates since they cannot be generated that easily in Excel. Let’s begin. I will use…