Badges
Tags
Categories
Meta
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
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
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
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
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
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
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
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
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
Alexander Batishchev's Blog 