Category Archives: Programming

Documentation as a Feature, Documentation is a Feature

TL;DR: documentation should be treated, i.e. planned, estimated and maintained, as any other functional part of a project. I don’t always write documentation but when I do, I believe it’s more important it to be up-to-date than to exist. That … Continue reading

Posted in Programming | Tagged , | Leave a comment

How to move data from SQL Server to ADLA table using ADF

In Universal Store Team, the Universal Payout Platform – Earnings Calculations project, we need to move data from on-prem SQL Server, as well as SQL Server within an Azure vnet and SQL Azure, to the Cloud. As our storage in … Continue reading

Posted in Programming | Tagged , | Leave a comment

How to deploy Azure Data Factory pipeline and its dependencies programatically using PowerShell

Since ADF doesn’t provide a built-in way for automated deployment, in order to do this you have to write a custom script. Then you can run it on build server such as VSTS or TeamCity. If you’re in the interactive … Continue reading

Posted in Programming | Tagged , | 44 Comments

How to enable tracing in ASP.NET Web API using Application Insights

Excert Continue reading

Posted in Programming | Tagged , , | Leave a comment

The ObjectContext instance has been disposed and can no longer be used for operations that require a connection

TL;DR: Don’t return task before disposing context, await it instead If you’re getting an Entity Framework exception: System.ObjectDisposedException: The ObjectContext instance has been disposed and can no longer be used for operations that require a connection at System.Data.Entity.Core.Objects.ObjectContext.ReleaseConnection() at System.Data.Entity.Core.Objects.ObjectContext.d__3d`1.MoveNext() … Continue reading

Posted in Programming | Tagged , | Leave a comment

Could not load file or assembly ‘Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference

TL;DR: Add reference to Newtonsoft.Json.dll in every project If you’re getting a runtime exception: System.IO.FileLoadException: Could not load file or assembly ‘Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly … Continue reading

Posted in Programming | Tagged | Leave a comment

How to generate ids programmatically using SQL Server and Entity Framework

TL;DR: create a sequence and execute stored proc to read from it Generating ids in the database is used to be the default and near to the only one approach but now days this trend is fading away. Here’s some … Continue reading

Posted in Programming | Tagged , | Leave a comment

How to push NuGet package to VSO feed v3

To push a nuget package to Visual Studio Online feed v3 use the following command: nuget.exe push MyPackage.1.0.0.nupkg -Source https://account.pkgs.visualstudio.com/DefaultCollection/_packaging/My_Feed/nuget/v3/index.json -ConfigFile nuget.config -ApiKey My_Feed The crucial part here is to include -ApiKey My_Feed, otherwise you’ll get 404 Not Found error. … Continue reading

Posted in Programming | Tagged , | Leave a comment

How to map linking table for many-to-many relationship using Entity Framework 6

TL;DR: use synonym. As promised earlier to myself, I blog about interesting challenges and the ways I solved them. The other day, me and my team faced a limitation in EF6: you can either configure a linking table for many-to-many … Continue reading

Posted in Programming | Tagged | Leave a comment

How to convert Google API Service Account certificate to base64

Recently in Google Developer Console by mistake I generated a new SSL certificate for my project’s Service Account so had to convert it again from p12 file to the base64 representation and store its thumbprint separately. Here’s how you can … Continue reading

Posted in Programming | Tagged | Leave a comment