How to resolve “Windows Principal functionality is not supported on this platform” in Azure App function

Introduction

I have designed an azure app function to process azure service bus queues and topics. The handlers in azure app function are aimed to process service bus messages into SQL database records through handlers. Whereas app functions are built on top of the code-first approach entity framework core 3.1. whenever I post message to Service bus topics I got “Windows principal functionality is not supported on this platform”. Let me explain you how I resolved this problem in this article

Problem

SQL Server comes handy with Mixed mode authentication where you can use either windows authentication or SQL Server authentication. I have created azure app function from .NET Core 3.1 and entity framework core 3.1.1 and provided local settings connection string with windows authentication mode.

“Server=myserver;Database=mydatabase;integrated security=true;”

In my case handlers can receive the message and processing it. While comes to saving point in database context it is throwing error while saving anything to this context.

Solution

I tried multiple ways to resolve this issue like reinstalling azure app functions related packages and reinstalling SQL Server, nothing helps. Finally, I have changed window authentication to SQL Server authentication. It’s works for me

“Server=yourserver;Database=yourdatabase;user id= yourid;password = yourpassword ;”

Conclusion

After the connection string changes from windows authentication mode to SQL server authentication mode, I can easily process the messages through handlers and database context saved the data successfully.

Comments

How to resolve ASP.NET core web API 2 mins timeout issue

Introduction We are in the new world of microservices and cross-platform applications which will be supported for multiple platforms and multiple heterogeneous teams can work on the same application. I like ASP.NET Core by the way its groomed to support modern architecture and adhere to the software principles. I am a big fan of dot net and now I become the craziest fan after seeing the sophisticated facility by dot net core to support infrastructure level where we can easily perform vertical and horizontal scaling. It very important design aspect is to keep things simple and short and by the way, RESTFul applications are build and it is a powerful mantra for REST-based application and frameworks. Some times we need to overrule some principles and order to handle some situations. I would like to share my situation of handling HTTP long polling to resolve the ASP.Net core 2 mins issue. What is HTTP Long polling? In the RESTFul term, when a client asks for a query from the serv

How to Resolve ASP.NET Core Key Protection Ring Problem in AWS Lambda

Introduction When it comes to server less web application design using asp.net core razor pages, we definitely need to consider a factor of data protection key management and its lifetime in asp.net core. I developed a site using AWS toolkit of ASP.NET Core Razor Pages. The main advantage of ASP.NET Core is cross-platform from where we can deploy our application in MAC, Linux or windows. I deployed my site initially in IIS Server from which I got the results as expected .but later period I decided to host my site in AWS Lambda in order to meet our client requirement. Strangely, I got unexpected behavior from my site. I just refer the cloud information Lambda Log to identify or pinpoint the case, I got the error Information like “Error Unprotecting the session cookie” from the log. In this article, I tried to explain the root cause of the problem and its solution to overcome such kind of issue. Data Protection in ASP.NET Core This is feature in ASP.NET Core which acts as repl

Which linq method performs better: Where(expression).FirstorDefault() vs .FirstOrDefault(expression)

Introduction When it comes to LINQ, we always have multiple options to execute the query for the same scenario. Choosing correct one is always challenging aspect and debatable one. In one of our previous articles Any Vs Count , we have done performance testing about best LINQ methods over .NET types. In this article, I would like to share about Where(expression).FirstorDefault() vs .FirstOrDefault(expression) Approaches Performance testing for Where(expression).FirstorDefault() vs .FirstOrDefault(expression) is very interesting IEnumerable<T> or ICollcetion<T> .FirstOrDefault(expression) is better than Where(expression).FirstorDefault() Public API To check the performance, I need some amount of data which should already available. So I decided to choose this public api . Thanks to publicapis Public API Models Entry class using System ; using System.Collections.Generic ; using System.Text ; namespace AnyVsCount { public class Entry { pub

Software Design Corner

Search This Blog