.NET developer blog

Using MSAL angular to authenticate a user against azure ADB2C via authorization code flow with Proof Key for Code Exchange.

Published March 2, 2023 in Angular , Azure , Azure ADB2C , OAuth2 , OpenID Connect , security - 1 Comment

Previously, I switched from using oidc-client to MSAL Angular to integrate an Angular app with Azure AD for authentication. If you’re interested, you can read more here. More recently, I used MSAL Angular again to connect another application, but this time to an Azure AD B2C tenant. Since I had prior experience and Microsoft provided good documentation and sample projects to follow, connecting to Azure AD B2C using MSAL Angular was not too difficult. In this post, I share how I adapted the sample project provided by Microsoft to integrate the application with our Azure AD B2C tenant and describe a few minor obstacles that I encountered.

Tags: authorization code flow with PKCE , azure-adb2c-user-flows , implicit flow , msal-angular , switch oidc-client to msal-angular

Using Azure Application Insights for centralized logging

Published February 1, 2023 in Azure , Logging - 1 Comment

A typical enterprise system usually runs on multiple servers behind a load balancer. The simplest logging option could be logging locally to a location on the server where the app runs. However, this setup makes triaging an issue using the logs difficult. The problem is more prominent if the system consists of multiple applications running on different servers, and the sessions are not sticky. When an error occurs, the developer has to go to the different servers and applications to gather the logs. Even when the developer has gathered all the logs, it may still be challenging to piece together the log events that belong to a same session in a chronological order to troubleshoot the issue.

Tags: azure-application-insights , azure-log-analytics , azure-monitoring

Analyzing a rental property through automation

Published December 31, 2022 in .NET , C#

In this post, I write about building an API to help me analyze real estate properties.

Tags: cap rate , cash flow , cash on cash return , net operating income , real estate investing , web scraping

Web scraping in C# using HtmlAgilityPack

Published October 16, 2022 in .NET , .NET core , C#

In this post, I show an example of scraping data in C# using HtmlAgilityPack. I come across HtmlAgilityPack because I need to get data from Zillow to analyze properties deals. I was able to scrape the data I want without much trouble using HtmlAgilityPack with a bit of XPath, LINQ and regular expression.

Tags: html-agility-pack , linq , regularexpression , web-scraping , xpath

Easily test sending and receiving email locally using MailHog

Published September 23, 2022 in Java , Testing

A java application which I work on has a feature to send emails via the corporate SMTP server to notify certain personnel whenever an error occurs. For security reasons, only servers within a certain networks can access the SMTP server and send emails. For instance, the computer which I use to build the application does not have access to the SMTP server. When searching for an email testing tool, I stumbled upon MailHog. Within minutes, I was able to run MailHog and test sending emails without having to deploy the app to the remote servers.

Tags: email , MailHog , mailtrap , smtp , SmtpClient

Building multitenant application – Part 3: Authentication

Published August 20, 2022 in Azure , Azure Active Directory

In this post, I continue to share what I have learned while building a multitenant application by ultilizing Microsoft Identity Framework and SQL role level security. Specifically, I share what I have learned following Microsoft example project and documentations to make authentication works in a multitenant environment.

Tags: azure authentication , identity management , Microsoft Identity Platform , multi-tenant , provisioning

Building multitenant application – Part 2: Storing value into database session context from ASP.NET core web API

Published August 13, 2022 in .NET , .NET core , ASP.NET core , Azure SQL database

In the previous post about row level security in SQL server, I gave an example of reading a value from the database session context to feed into the security function for filtering data. In this post, I show examples of calling the sp_set_session_context store procedure from an ASP.NET core web API to store a value into the session context.

Tags: entity framework , entity framework core , multitenant , row level security , session context , sql server

Building multitenant application – Part 1: Multitenant database using Row Level Security

Published July 29, 2022 in ASP.NET core , Azure , Azure SQL database , Database

In this and upcoming posts, I’ll be sharing what I have learned while implementing a multi-tenant solution. Specifically, in this post, I share my understanding about Row Level Security in SQL server, and how I have utilized it to host data for multiple organizations in a way that is transparent to the users.

Tags: multi-tenant , row-level-security , security-policy , sql-server , table-value-function

Displaying text in a tool tip when text overflows its container

Published June 16, 2022 in Angular - 1 Comment

In several apps I work on, we use angular material to display data in a table. Sometimes, long text causes the height of the table cells to increase, resulting in an unaesthetic UI.

Tags: angular material , angular material table , angular material tooltip , tooltip , word-wrap

Migration from Oracle to azure SQL caveat – Azure SQL does not support time zone settings

Published June 4, 2022 in Azure , Azure SQL database

In this post, I continue to share what I have learned while working with my team to migrate our application and database from Oracle to azure SQL. Specially, I share an issue we encounter with time zone in azure SQL.

Tags: azure-sql , azure-sql-database , offset , sql managed instance , timezone

« Previous 1 2 3 4 … 11 Next »