Category: All

EntityFramework Core Scaffolding

If you already have a database and want to use EF Core for your database/object mapping, the Scaffold-DbContext command can be run from within Visual Studio, using the Package Manager Console. If it isn’t open, you can get to it from the View/Other Windows menu command. This is an example of how to generate DbContext and entity mapping objects:

Scaffold-DbContext “Server=.\SQLEXPRESS01;Database=***;Trusted_Connection=True” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Objects

The command targets SQL Server using the currently logged on user account. Make sure you select the correct project, if you more than one in your solution, from the Default Project list in the
Package Manager Console.

Notice how I have a single backslash for the server name. In your connection string, potentially stored in the appsettings.json file, you’ll need two backslashes, Server=.\\SQLEXPRESS01. If you have two backslashes when running the Scaffold-DbContext command, the command will fail, with this exception:

System.InvalidOperationException: Instance failure.
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)

Don’t forget the -Force option in your command, if you want to replace an existing DbContext and mapping objects.


A bewildered recruiter

I got an email yesterday from a recruiter on LinkedIn via Inmail, which I normally treasure. Here’s how the email begins…

Hi Carsten,

I hope you’re well.

You were recommended to me (most highly) this morning by someone who used to work with you at ******* and I happen to have a role that matches your skill set.

Looked good so I replied…

Hi ****,

Well, why don’t you tell who recommended me, and we can have a chat?

Here’s the pathetic reply…

Hi Carsten,

Thanks for coming back to me. The chap who gave me your name told us to keep his name confidential as he wasn’t sure if you were looking for a new role or not. Sorry!

Shall I send the spec?

So the person recommending me most highly, wouldn’t let me know who he is? ūüėāūüėāūüėā What a joke…

Here’s my reply…

Don’t bother mate, it’s all bullshit, so go elsewhere with your crap.

Hertz Club DK medlem?

Er du udlandsdansker, og på vej til Danmark ved jule- eller nytårstid? Så kig lige her, og hvis du ikke allerede har modtaget en email fra Club DK, så læs nedenfor.

Vi er meget stolte over Club DK og over at have medlemmer fordelt på 149 lande.
Vi synes, at I er spændende og er nysgerrige omkring jeres eventyr ude i verden og jeres glæde ved at komme hjem.

Vi vil som noget nyt introducere Club DK interviews i filmformat.
Har du lyst til at blive interviewet om livet ude på eventyr og det helt særlige ved at komme hjem?

Hvor: Kastrup/K√łbenhavnsomr√•det.
Hvornår: i december/januar
Hvordan: Interview i en bil
Varighed: Ca. 30 minutter
Færdigklippet interview: Ca. 3 minutter

Som tak for deltagelse giver vi en voucher til et weekendlejem√•l (bilgruppe C) som kan benyttes i l√łbet af 2019.

Vi kontakter de personer, som er i Danmark de datoer, hvor det er muligt for os at filme.
Har du sp√łrgsm√•l er du mere end velkommen til at kontakte Tilmeld dig her


I did an early run this morning in Cassiobury Park and along the Grand Union Canal towpath, as I have done a good few times before. This time it was really dark, just before 4:30, but I kind of love that. ūüôā Being on your own, meeting nothing but deers, hares, foxes and all sorts of birds is just a lovely “companion” when out there. I absolutely love these half marathon runs, they complete me to some extent. Just saying… BTW, I could do with a running partner anywhere near Watford…


Over the last few years I’ve had various people come up to me, asking me if I was High Dennis. ūüėĪ I’m clearly not, but I’ll take it ūüôā Have you ever had that experience, that someone mistakes or thinks you resemble a celebrity? It’s odd, and I can only apologise to the man himself, he has no need for a doppelg√§nger. ūüėé

Windows Insider Programme

I’ve been part of the Windows Insider programme for quite a while now (January 14, 2015), and I have generally been very pleased with my participation. Today I installed the¬†Windows 10 Insider Preview 18272.1000 (rs_prerelease), from my favourite Pr√©t coffee joint in Watford.

It took a while to download, but the actual installation was very quick, and it seems MS has been working on speeding up new OS upgrades over at least the last year. I’ve been using my trusted Lenovo Flex-2 15 for most of the builds. It is nearly 5 years old, and rarely had any issues with drivers etc, so I’m well pleased with the Windows OS, in particularly the Windows Insider builds. I’m now on the Active development of Windows preview build, on the Fast ring. I am running my development tools, Visual Studio 2017, Visual Studio Code etc, on these builds and rarely have any issues. Keep it up MS!

Visual Studio 2017 Editor new line wrapping

We all have our favourite settings when it comes to setting up Visual Studio, and the editor is quite often set up differently for a group of developers working together. I like having the opening brace ({) on the same line as the class, struct or whatever the brace signals the beginning of.

I like this:

class {

as compared to this:


I frequently use the key combination Ctrl+K, Ctrl+D to format my document after having typed some code. I dislike it, if the formatting is not to my liking. It should therefore not come as a surprise, if I tell you that while working on a new UWP app, in which I had copied across some code from a Template10 project template, the key combo seemingly didn’t work anymore. After some investigation, including opening an existing Console app, in which the key combo did work, I took a look at this code:

namespace Template10.Views
    public sealed partial class SettingsPage : Page
        readonly Template10.Services.SerializationService.ISerializationService _serializationService;
        public SettingsPage()
            NavigationCacheMode = NavigationCacheMode.Required;
            _serializationService = Template10.Services.SerializationService.SerializationService.Json;
        protected override void OnNavigatedTo(NavigationEventArgs e)
            var index = int.Parse(_serializationService.Deserialize(e.Parameter?.ToString()).ToString());
            MyPivot.SelectedIndex = index;

Because of the Page class, from which the class shown, SettingsPage, is derived has a notification stating “Base type ‘Page’ is already specified in other parts”, the class/type name Page is greyed out. This effectively blocks for the document formatting placing the opening brace { on the same line as the class declaration. If I remove : Page, and press the key combination Ctrl+K, Ctrl+D, this is what I get.

namespace Template10.Views {
    public sealed partial class SettingsPage {
        readonly Template10.Services.SerializationService.ISerializationService _serializationService;
        public SettingsPage() {
            NavigationCacheMode = NavigationCacheMode.Required;
            _serializationService = Template10.Services.SerializationService.SerializationService.Json;
        protected override void OnNavigatedTo(NavigationEventArgs e) {
            var index = int.Parse(_serializationService.Deserialize(e.Parameter?.ToString()).ToString());
            MyPivot.SelectedIndex = index;


MS Band 2 battery dead

I’ve been using MS Band for a few years, initially the original Band and then the MS Band 2. I’ve had the latter replaced twice, but now that device is no longer able to be charged, i.e. the battery is fucked, and of course I’m out of warranty. I love my Band and I wear it all the time, it’s a fantastic little device and I pray to the MS Gods they will bring out a new and even better one sometime soon.

However, what do I do in the meantime, I really need a device for when I go running or walking… Any ideas?