Category Archives: Development

Dotnet development

Lift and shift SSIS package

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)

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

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

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

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