CSS Blogs & News @CODEKICKER

7

How to run a legacy WCF .svc Service on Azure AppService

Last month we wanted to run good old WCF powered service on Azures “App Service”. WCF… what’s that? If you are not familiar with WCF: Good! For the interested ones: WCF is or was a framework to build mostly SOAP based services in the .NET Framework 3.0 timeframe. Some parts where “good”, but most developers would call it a complex monster. Even in the glory days of WCF I tried to avoid it ...

01.09.2020 | 91 1 | Code-Inside Blog

8

EWS, Exchange Online and OAuth with a Service Account

This week we had a fun experiment: We wanted to talk to Exchange Online via the “old school” EWS API, but in a “sane” way. But here is the full story: Our goal We wanted to access contact information via a web service from the organization, just like the traditional “Global Address List” in Exchange/Outlook. We knew that EWS was on option for the OnPrem Exchange, but what about Exchange ...

01.08.2020 | 98 1 | Code-Inside Blog

10

Can a .NET Core 3.0 compiled app run with a .NET Core 3.1 runtime?

Within our product we move more and more stuff in the .NET Core land. Last week we had a disussion around needed software requirements and in the .NET Framework land this question was always easy to answer: .NET Framework 4.5 or higher. With .NET Core the answer is sligthly different: In theory major versions are compatible, e.g. if you compiled your app with .NET Core 3.0 and a .NET ...

01.07.2020 | 339 1 | Code-Inside Blog

11

SqlBulkCopy for fast bulk inserts

Within our product OneOffixx we can create a “full export” from the product database. Because of limitations with normal MS SQL backups (e.g. compatibility with older SQL databases etc.), we created our own export mechanic. An export can be up to 1GB and more. This is nothing to serious and far from “big data”, but still not easy to handle and we had some issues to import larger ...

01.06.2020 | 318 1 | Code-Inside Blog

6

Blazor for Office Add-ins: First look

Last week I did some research and tried to build a pretty basic Office Addin (within the “new” web based Addin model) with Blazor. Side note: Last year I blogged about how to build Office Add-ins with ASP.NET Core. Why Blazor? My daily work home is in the C# and .NET land, so it would be great to use Blazor for Office Addins, right? A Office Add-in is just a web application with a ...

30.04.2020 | 350 2 | Code-Inside Blog

7

Escape enviroment variables in MSIEXEC parameters

Problem Customers can install our product on Windows with a standard MSI package. To automate the installation administrators can use MSIEXEC and MSI parameters to configure our client. A simple installation can look like this: msiexec /qb /i "OneOffixx.msi" ... CACHEFOLDER "D:/OneOffixx/" The “CACHEFOLDER” parameter will be written in the .exe.config file and our program ...

28.03.2020 | 333 1 | Code-Inside Blog

5

TLS/SSL probelems: 'Could not create SSLTLS secure channel'

Problem Last week I had some fun debugging a weird bug. Within our application one module makes HTTP requests to a 3rd party service and depending on the running Windows version this call worked or failed with: 'Could not create SSLTLS secure channel' I knew that older TLS/SSL versions are deprecated and that many services refuse those protocols, but we still didn’t finally ...

01.03.2020 | 444 5 | Code-Inside Blog

9

Accessibility Insights: Spot accessibilities issues easily for Web Apps and Windows Apps

Accessibility Accessibility is a huge and important topic nowadays. Keep in mind that in some sectors (e.g. government, public service etc.) accessibility is a requirement by law (in Europe the European Standards EN 301 549). If you want to learn more about accessibility in general this might be handy: MDN Web Docs: What is accessibility? Tooling support In my day to day job for ...

01.02.2020 | 420 4 | Code-Inside Blog

9

T-SQL Pagination

The problem This is pretty trivial: Let’s say you have blog with 1000 posts in your database, but you only want to show 10 entries “per page”. You need to find a way how to slice this dataset into smaller pieces. The solution In theory you could load everything from the database and filter the results “in memory”, but this would be quite stupid for many reasons (e.g. you load much more ...

31.12.2019 | 695 13 | Code-Inside Blog

6

Did you know that you can build .NET Core apps with MSBuild.exe?

The problem We recently updated a bunch of our applications to .NET Core 3.0. Because of the compatibility changes to the “old framework” we try to move more and more projects to .NET Core, but some projects still target “.NET Framework 4.7.2”, but they should work “ok-ish” when used from .NET Core 3.0 applications. The first tests were quite successful, but unfortunately when we ...

01.12.2019 | 295 0 | Code-Inside Blog

10

IdentityServer & Azure AD Login: Unkown Response Type text/html

The problem Last week we had some problems with our Microsoft Graph / Azure AD login based system. From a user perspective it was all good until the redirect from the Microsoft Account to our IdentityServer. As STS and for all auth related stuff we use the excellent IdentityServer4. We used the following configuration: services.AddAuthentication() ...

13.10.2019 | 410 2 | Code-Inside Blog

7

Enforce Administrator mode for builded dotnet exe applications

The problem Let’s say you have a .exe application builded from Visual Studio and the application always needs to be run from an administrator account. Windows Vista introduced the “User Account Control” (UAC) and such applications are marked with a special “shield” icon like this: TL;DR-version: To build such an .exe you just need to add a __“application.manifest” and request ...

30.09.2019 | 252 1 | Code-Inside Blog

6

Check installed version for ASP.NET Core on Windows IIS with Powershell

The problem Let’s say you have a ASP.NET Core application without the bundled ASP.NET Core runtime (e.g. to keep the download as small as possible) and you want to run your ASP.NET Core application on a Windows Server hosted by IIS. General approach The general approach is the following: Install the .NET Core hosting bundle and you are done. Each .NET Core Runtime (and there are ...

01.09.2019 | 519 8 | Code-Inside Blog

5

SQL Server, Named Instances & the Windows Firewall

The problem “Cannot connect to sql\instance. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating ...

01.08.2019 | 399 7 | Code-Inside Blog

7

Jint: Invoke Javascript from .NET

If you ever dreamed to use Javascript in your .NET application there is a simple way: Use Jint. Jint implements the ECMA 5.1 spec and can be use from any .NET implementation (Xamarin, .NET Framework, .NET Core). Just use the NuGet package and has no dependencies to other stuff - it’s a single .dll and you are done! Why should integrate Javascript in my application? In our product ...

01.07.2019 | 325 0 | Code-Inside Blog

7

Build Windows Server 2016 Docker Images under Windows Server 2019

Since the uprising of Docker on Windows we also invested some time into it and packages our OneOffixx server side stack in a Docker image. Windows Server 2016 situation: We rely on Windows Docker Images, because we still have some “legacy” parts that requires the full .NET Framework, thats why we are using this base image: FROM ...

01.06.2019 | 447 5 | Code-Inside Blog

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 | 470 4 | Code-Inside Blog

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 | 376 0 | Code-Inside Blog

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 | 818 37 | Code-Inside Blog

8

Office Add-ins with ASP.NET Core

The “new” Office-Addins Most people might associate Offce-Addins with “old school” COM addins, but since a couple of years Microsoft pushes a new add-in application modal powered by HTML, Javascript and CSS . The cool stuff is, that these add-ins will run unter Windows, macOS, Online in a browser and on the iPad. If you want to read more about the general aspects, just checkout the ...

01.02.2019 | 512 0 | Code-Inside Blog

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 | 817 29 | Code-Inside Blog

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 | 790 0 | Code-Inside Blog

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 | 490 3 | Code-Inside Blog

7

How to fix ERR_CONNECTION_RESET & ERR_CERT_AUTHORITY_INVALID with IISExpress and SSL

This post is a result of some pretty strange SSL errors that I encountered last weekend. The scenario: I tried to setup a development environment for a website that uses a self signed SSL cert. The problem occured right after the start - especially Chrome displayed those wonderful error messages: ERR_CONNECTION_RESET ERR_CERT_AUTHORITY_INVALID The “maybe” solution: When you ...

01.11.2018 | 1552 10 | Code-Inside Blog

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 | 577 1 | Code-Inside Blog

1 Mitglieder	online
2421 Gäste	online
3 neue Beiträge heute
Antwortzeit 0,0 Minuten

	XML File einlesen in DataGr...
	Teambeam automatisiert mit ...
	XML Combobox
	Listbox Item in LOG TXT stä...