ODP.NET hang on Insert with return value within a Transaction

Introduction So, you are finding that ODP.NET seems to be hanging on a second insert within a loop which is part of a transaction.. and it's driving you crazy yeah? The only thing that you notice is that it is essentially the same insert statement each iteration of the loop for a valid business reason; …

Upgrading to Team Foundation Server 2015 Update 2.1

How to upgrade an on premises Team Foundation Server to version 2015 update 2.1 Recently I had the task of upgrading our on premises TFS solution from TFS 2013 Update 5 to TFS 2015 Update 2.1. This article discusses the upgrade steps, how long the process took, as well as some of the pitfalls with …

Working with Sass in Visual Studio 2015

Introduction Sass is the perfect modern solution for maintaining many large complex CSS files, and keeping the CSS code DRY; with many developers using Sass now to overcome these maintenance problems. If you have never heard of Sass and want to learn more then look at the sections below. The official Sass website describes Sass as: Sass …

Dependency Injection and IoC in .NET with Unity

Introduction Dependency Injection in .NET is not a complicated concept to understand and implement; however when working on projects with other developers I often see them using the new keyword to create a dependant object (i.e. concrete class), rather than using the dependency injection design pattern alongside interfaces, and its a code smell to me personally when I see …

SSIS MySQL to Azure SQL using Visual Studio 2015

Introduction Recently I had the pleasure of using SSIS (SQL Server Integration Services) to transfer a database from a remote MySQL database to an Azure SQL database in the cloud. This post describes the steps in transferring the data using SSIS through Visual Studio 2015 and the integrated BI Data Tools. What is SSIS? Microsoft …

Enterprise Library 6 Semantic Logging to Azure SQL Database

What is the Semantic Logging block? Any time I need to log to a database, flat file, console, or event viewer I always go back to the Microsoft Enterprise Library. The Enterprise Library is a set of components created by Microsoft to simplify and standardise common software development using best practice and patterns. Microsoft describe …

Speed up .NET development with the CodeDOM

How to speed up .NET development using the CodeDOM and Reflection I recently worked on an ASP.net AngularJS/WebAPI hybrid project which had around 45 models linked to SQL Server tables using Entity Framework (nothing too unusual there); and the requirements in the product backlog was to create files for each. I am not talking 45 different files here.. I am …