Category Archives: Development

Dotnet development

Lift and shift SSIS package

Posted on October 15, 2020 by erictummers

We use Sql Server Integration Services (SSIS) to import text files into our database. The dtsx files are deployed into the MSDB on the Sql Server. Everything works well with deployment with a powershell DSC script. But times change and … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Webapi core 2.1 and jQuery (CORS)

Posted on July 3, 2020 by erictummers

I’ve written before about Cordova, AngularJs, WebApi and CORS. (Cross Origin Resource Sharing) Now we have te same hurdle to take with our dotnet core 2.1 webapi. Since the webapi is on a webserver and accessible to third parties we decided … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Bogus – testdata generator

Posted on May 1, 2020 by erictummers

Photo by Steve Harvey on Unsplash https://www.nuget.org/packages/bogus Creating testdata is not my favourite task. With bogus I can define the rules the data must adhere and generate as much data as I need. The rules are setup with fluent syntax … Continue reading →

Posted in Development, Tooling | Tagged , , , | Leave a comment

EF core: entity cannot be tracked

Posted on April 21, 2020 by erictummers

We use EF core to store a bulk of data with an auto-number primary key. The auto-number is an Identity column in Sql Server. When inserting a large amount of records with related children we encounter this error: System.InvalidOperationException entity … Continue reading →

Posted in Development, Tooling | Tagged , , , | Leave a comment

Logging from Automapper

Posted on April 10, 2020 by erictummers

We’ve been using automapper to convert objects for some time. Now I have the need for logging to help bugtracking. Below a short list of sources how we set this up. And now you’ll need a serviceprovider when unittesting. Thank … Continue reading →

Posted in Development | Tagged , , , | Leave a comment