Code-Inside Blog @CODEKICKER

5

Update OnPrem TFS 2018 to AzureDevOps Server 2019

We recently updated our OnPrem TFS 2018 installation to the newest release: Azure DevOps Server The product has the same core features as TFS 2018, but with a new UI and other improvements. For a full list you should read the Release Notes. *Be aware: This is the OnPrem solution, even with the slightly missleading name “Azure DevOps Server”. If you are looking for the Cloud solution ...

01.05.2019 | 35 0

9

Load hierarchical data from MSSQL with recursive common table expressions

Scenario We have a pretty simple scenario: We have a table with a simple Id ParentId schema and some demo data in it. I have seen this design quite a lot in the past and in the relational database world this is the obvious choice. Problem Each data entry is really simple to load or manipulate. Just load the target element and change the ParentId for a move action etc.. A more complex ...

01.04.2019 | 50 0

6

Check Scheduled Tasks with Powershell

Task Scheduler via Powershell Let’s say we want to know the latest result of the “GoogleUpdateTaskMachineCore” task and the corresponding actions. All you have to do is this (in a Run-As-Administrator Powershell console) : Get-ScheduledTask where TaskName -EQ 'GoogleUpdateTaskMachineCore' Get-ScheduledTaskInfo The result should look like this: LastRunTime : ...

27.02.2019 | 125 4

8

Office Add-ins with ASP.NET Core

... powered by HTML, Javascript and CSS . The cool stuff is, that ... Studio Template: Urgh… ASP.NET Because of the “new” nature of ... templates still uses ASP.NET and not ASP.NET Core. ASP.NET Core Sample If you want to use ASP.NET Core, you might ... look at my ASP.NET Core-sample. It is ... Warning: In the “ASP.NET ”-Offce-Addin-development world there ... be working with ASP.NET Core projects. The ...

01.02.2019 | 231 0

4

How to use TensorFlow with AMD GPU's

How to use TensorFlow with AMD GPU’s Most machine learning frameworks that run with a GPU support Nvidia GPUs, but if you own a AMD GPU you are out of luck. Recently AMD has made some progress with their ROCm platform for GPU computing and does now provide a TensorFlow build for their gpus. Since I work with tensorflow and own a AMD GPU it was time to give it a try. I stumpled upon these ...

05.12.2018 | 410 29

6

Make your WCF Service async

Oh my: WCF??? This might be the elephant in the room: I wouldn’t use WCF for new stuff anymore, but to keep some “legacy” stuff working it might be a good idea to modernize those services as well. WCF Service/Client compatibility WCF services had always close relationships with their clients and so it is no suprise, that most guides show how to implement async operations on the server ...

03.12.2018 | 400 0

11

HowTo: Run a Docker container using Azure Container Instances

Azure Container Instances There are (at least) 3 diffent ways how to run a Docker Container on Azure: Using the Web App for Containers Using Azure Kubernetes Service (AKS) Using Azure Container Instances In this blogpost we will take a small look how to run a Docker Container on this service. The “Azure Container Instances”-service is a pretty easy service and might be a good first ...

13.11.2018 | 160 0

7

How to fix ERR_CONNECTION_RESET & ERR_CERT_AUTHORITY_INVALID with IISExpress and SSL

... environment for a web site that uses ... & IIS Express related certs ... IIS Express? Well - ... IIS Express certs I ... IIS Express installation and ... IIS Express was working ... IIS Express at least ... IIS Express certs in ... IIS Express via the ... IIS Express via the ... “Iis ExpressAdminCmd.exe” - this ... IIS Express bitness settings. ... “net sh” from a ... net sh), e.g.: net sh http delete ... net sh http add ... net sh tool, but ... Iis ...

01.11.2018 | 274 7

9

Be afraid of varchar(max) with async EF or ADO.NET

Last month we had changed our WCF APIs to async implementations, because we wanted all those glorious scalability improvements in our codebase. The implementation was quite easy, because our service layer did most of the time just some simple EntityFramework 6 queries. The field test went horribly wrong After we moved most of the code to async we did a small test and it worked quite ...

27.09.2018 | 199 1

3

Migrate a .NET library to .NET Core / .NET Standard 2.0

... to .NET Standard 2.0. This ... .NET Standard. Uhmmm… wait… ... .NET Standard? If you ... .NET Standard is a ... .NET implementations like the ... .NET Framework or .NET Core. But hold ... .NET implementations that support ... .NET Standard Back to ... .NET Framework. All projects ... .NET Standard 2.0 The ... .NET Core and .NET Standard Made Easy” ... .NET Standard projects and ... .NET Standard I really ... .NET Standard library ...

31.08.2018 | 204 0

4

Improving Code

Improving code TL;DR; Things I learned: long one-liners are hard to read and understand split up your code into small, easy to understand functions less “plumping” (read infrastructure code) is the better get indentation right “Make it correct, make it clear, make it concise, make it fast. In that order.” Wes Dyer Why should I bother? Readable code is: easier to debug fast to fix ...

03.08.2018 | 172 1

7

Easy way to copy a SQL database with Microsoft SQL Server Management Studio (SSMS)

How to copy a database on the same SQL server The scenario is pretty simple: We just want a copy of our database, with all the data and the complete scheme and permissions. 1. step: Make a back up of your source database Click on the desired database and choose “Backup” under tasks. 2. step: Use copy only or use a full backup In the dialog you may choose “copy-only” backup. With this option ...

01.08.2018 | 217 2

9

DbProviderFactories & ODP.NET: When even Oracle can be tamed

Oracle and .NET : Tales from the dark ages ... add some config entries in your web .config or app.config. I will cover ... earlier after the installation your web or app.config might look different. The ... Data Provider for .NET , Managed Driver" type "Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, ... a Oracle database from .NET doesn’t need to be a pain ...

01.06.2018 | 520 2

9

CultureInfo.GetCultureInfo() vs. new CultureInfo() - what's the difference?

The problem The problem started with a simple code: double.TryParse("1'000", NumberStyles.Any, culture, out _) Be aware that the given culture was “DE-CH” and the Swiss use the ‘ for the separator for numbers. Unfortunately the Swiss authorities have abandoned the ‘ for currencies, but it is widly used in the industrie and such a number should be parsed or displayed. Now ...

29.05.2018 | 581 0

6

.editorconfig: Sharing a common coding style in a team

... I ended up with the .editorconfig of the CoreCLR. It is more or less the “normal” .NET style guide. I’m not sure if I love the the “var”-setting and the “static private field naming (like ... code analysis as part of their NuGet packages. Because these analyzers are powered by the .NET Compiler Platform (code-named “Roslyn”), they can produce warnings in your code as you type even before ...

01.05.2018 | 909 0

11

Did you know that you can run ASP.NET Core 2 under the full framework?

... default way: Running .NET Core AFAIK the ... matter anyway for .NET Core related projects. ... create a new ASP.NET Core application you ... upper left corner: .NET Core is currently ... PropertyGroup TargetFramework net coreapp2.0 /TargetFramework /PropertyGroup ... TargetFramework net 461 /TargetFramework /PropertyGroup ... .NET Framework you can’t ... .NET Core only, and ... ASP.NET Core 2.1 the ...

01.04.2018 | 794 0

6

Windows Fall Creators Update 1709 and Docker Windows Containers

Who shrunk my Windows Docker image? We started to package our ASP.NET /WCF/Full-.NET Framework based web app into Windows Containers, which we then publish to the Docker Hub. Someday we discovered that one of ... from March(?). Docker resolves the base images for Windows like this: If you pull the ASP.NET Docker image from a Windows 10 Client OS with the Fall Creators Update you will ...

28.02.2018 | 244 0

7

WCF Global Fault Contracts

If you are still using WCF you might have stumbled upon this problem: WCF allows you to throw certain Faults in your operation, but unfortunatly it is a bit awkward to configure if you want “Global Fault Contracts”. With this solution here it should be pretty easy to get “Global Faults”: Define the Fault on the Server Side: Let’s say we want to throw the following fault in all our ...

01.02.2018 | 256 0

8

First steps to enable login with Microsoft or Azure AD account for your application

... less legacy and I wouldn’t use them anymore. Step 2: Choose a platform Now you need to choose your application platform. If you want to enable the sign-in stuff for your web application you need to choose “Web ” and insert the redirect URL. After the sign-in process the token will be send to this URL. Step 3: Choose Microsoft Graph Permissions (Scopes) In the last step you need to select ...

31.12.2017 | 266 0

8

Signing with SignTool.exe - don't forget the timestamp!

If you currently not touching signtool.exe at all or have nothing to do with “signing” you can just pass this blogpost, because this is more or less a stupid “Today I learned I did a mistake”-blogpost. Signing? We use authenticode code signing for our software just to prove that the installer is from us and “safe to use”, otherwise you might see a big warning from Windows that the ...

02.12.2017 | 808 0

10

Signing with SignTool.exe - don't forget the timestamp!

If you currently not touching signtool.exe at all or have nothing to do with “signing” you can just pass this blogpost, because this is more or less a stupid “Today I learned I did a mistake”-blogpost. Signing? We use authenticode code signing for our software just to prove that the installer is from us and “safe to use”, otherwise you might see a big warning from Windows that the ...

01.12.2017 | 318 0

8

Introducing Electron.NET - building Electron Desktop Apps with ASP.NET Core

... known Electron and .NET . If you ... desktop apps with ASP.NET Core (or .NET Core in general) ... stack available for .NET Core. After a ... and somehow “embed” ASP.NET Core in it. ... to launch the ASP.NET Core application inside ... APIs from the .NET World. First steps ... the ASP.NET Core process The ... .NET Core process with ASP.NET Core port (e.g. ... ASP.NET Core app and ... Web Host - maybe ... web server inside the ...

01.11.2017 | 1073 0

10

dnSpy - a OSS IL decompiler and debugger

... allowed to install anything. Soooo… he searched around and found this: dnSpy - a .NET assembly editor, decompiler, and debugger The title contains the major points. It is a decompiler, ... to make sure you keep this in mind: The debugging works with every .NET application (at least in theory), because it decompiles the .NET IL language to C#. It is not a 1:1 debugger, but maybe it can help ...

01.10.2017 | 704 2

4

IdentityServer3 with WindowsAuthentication with ASP.NET WebApi & ASP.NET & WPF App

... be hosted via IIS (or IIS Express) with Windows authentication enabled. The ASP.NET app acts as ... The Web App itself can ... also hosts a Web Api. The Web Api is secured ... via a Web Browser-Control from the ... Web Api that is ... ASP.NET application. To include ... IIS Express or something ... ‘Web App’ Project This ... ASP.NET MVC project with Web Api 2 included. ... ASP.NET Core related, but ... Web Api Browser Auth ...

31.08.2017 | 628 0

6

How to convert .crt & .key files to a .pfx

The requirements are simple: You will need the .cer with the corresponding .key file and need to download OpenSSL. If you are using Windows without the awesome Linux Subsystem, take the latest pre-compiled version for Windows from this or this site. Otherwise with Bash on Windows you can just use OpenSSL via its “native” environment. Thanks for the hint @kapsiR After the download ...

01.08.2017 | 1140 2

Code-Inside Blog

News und Artikel von Code-Inside Blog