CSS Blogs & News @CODEKICKER

9

Microsoft Graph: Read user profile and group memberships

In our application we have a background service, that “syncs” user data and group membership information to our database from the Microsoft Graph. The permission model: Programming against the Microsoft Graph is quite easy. There are many SDKS available, but understanding the permission model is hard. ‘Directory.Read.All’ and ‘User.Read.All’: Initially we only synced the ...

01.02.2021 | 205 0 | Code-Inside Blog

5

How to get all distribution lists of a user with a single LDAP query

In 2007 I wrote a blogpost how easy it is to get all “groups” of a given user via the tokenGroup attribute. Last month I had the task to check why “distribution list memberships” are not part of the result. The reason is simple: A pure distribution list (not security enabled) is not a security group and only security groups are part of the “tokenGroup” attribute. After some thoughts and ...

31.12.2020 | 366 5 | Code-Inside Blog

9

Update AzureDevOps Server 2019 to AzureDevOps Server 2019 Update 1

... itself don’t use the Windows Certificate Store. To resolve this, the root certificate from our Domain controller must be stored on the agent. [Environment]::SetEnvironmentVariable(“NODE_EXTRA_CA_CERTS”, “C:\SSLCert\root-CA.pem”, “Machine”) Summary The update itself was easy, but it took us some hours to configure our Build Agents. After the initial hiccup it went ...

30.11.2020 | 432 4 | Code-Inside Blog

6

DllRegisterServer 0x80020009 Error

Last week I had a very strange issue and the solution was really “easy”, but took me a while. Scenario For our products we build Office COM Addins with a C based “Shim” that boots up our .NET code (e.g. something like this. As the nature of COM: It requires some pretty dumb registry entries to work and in theory our toolchain should “build” and automatically “register” the output. ...

01.11.2020 | 334 3 | Code-Inside Blog

7

How to share an Azure subscription in a team

We at Sevitec are moving more and more workloads for us or our customers to Azure. So the basic question needs an answer: How can a team share an Azure subscription? Be aware: This approach works for us. There might be better options. If we do something stupid, just tell me in the comments or via email - help is appreciated. Step 1: Create a directory We have a “company directory” with a ...

30.09.2020 | 371 2 | Code-Inside Blog

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 | 509 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 | 392 2 | 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 | 637 4 | 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 | 480 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 | 625 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 | 482 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 | 635 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 | 576 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 | 911 21 | 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 | 442 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 | 582 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 | 379 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 | 686 10 | 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 | 548 8 | 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 | 465 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 | 589 7 | 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 | 604 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 | 503 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 | 1250 44 | 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 | 648 0 | Code-Inside Blog

0 Mitglieder	online
3095 Gäste	online
0 neue Beiträge heute
Antwortzeit 1110,9 Minuten

	Warum ist Scrum oder Agile ...
	Datagrid csv read
	Datagrid csv read
	Datagrid csv read