Skip to main content

Posts

Showing posts with the label .NET Core

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 thr
Post a Comment
Read more

How to pivot complex list object into comma delimited CSV string in c#

Introduction In SQL, PIVOT Function used to convert rows to the column.Likewise , In c# we can use string.join method to pivot integer and string collection easily to an any delimeted character . In case of complex objects really it is pain to pivot or transpose into some specified format like CSV   formatted string .In this article , I would like   to explain how to pivot complex list object into comma delimeted CSV string of dynamic columns.Let us look into this, Sample Use  Case We need to convert the list object elements to specific dynamic columned CSV Format string. For example, consider this employee list object var employees = new List { new Employee {Id="1", Name="Sekar" , Address="Valapady" } , new Employee {Id="2", Name="Divya" , Address="Salem" }, new Employee {Id="3", Name="Iniyan" , Address="Belur" }, new
Post a Comment
Read more

How to convert list object to CSV format string in c#

Introduction Working with data structures is interesting when it comes to conversion according to our needs some kind of generic functionality ties hands with us throughout the entire project. So we need to be more focused on implementing such kind of functionalities. In this article, I will walk through the conversion of the list to CSV string using c#. Let us look into this Example use case Let us consider this example, we are having employees list object for which we should do the conversion to a CSV string using c# without string.join method var employees = new List { new Employee {Id="1", Name="Sekar" , Address="Valapady,Salem" } , new Employee {Id="2", Name="Tamil" , Address="Mangalapuram" }, new Employee {Id="3", Name="Iniyan" , Address="Belur" }, new Employee {Id="4", Name="Vijai" , Addr
1 comment
Read more

Popular posts from this blog

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
6 comments
Read more

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
4 comments
Read more

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
Post a Comment
Read more