.NET developer blog

Migrating from Oracle to Azure SQL caveat – prepared statement set string causes implicit conversion

Published June 1, 2022 in Azure , Azure SQL database

In the previous post, I discuss the issue we face with storing date and time after migrating to azure SQL and the solution. If interested, you can check it out here. In this post, I talk about an issue we encountered with regards to implicit conversion, causing high CPU usage and performance degradation.

Tags: implicit conversion , nvarchar , sendStringParametersAsUnicode , sqljdbc , varchar

Migrating from Oracle to Azure SQL caveat – java.sql.Date does not represent time.

Published May 28, 2022 in Azure , Azure SQL database , Java , Oracle , Oracle database

My team recently migrated one of our main database from Oracle to Azure SQL database. In this and upcoming posts, I’m going to share a few things I have learned during the process. Specifically, in this post, I share an issue we ran into with storing date and time, after migrating the schema and data from our Oracle into azure SQL database.

Tags: ojdbc , sql-date , sql-timestamp , sqljdbc

Azure AD authentication in angular using MSAL angular v2 library

Published April 27, 2022 in Angular , ASP.NET core , Azure , Azure Active Directory , OAuth2 , OpenID Connect , security - 2 Comments

In previous projects, I use Oidc-client-js to authenticate users against azure AD. Oidc-client-js is a great library but is no longer maintained by the main author. Because of this, I have switched to MSAL angular v2 in my current project. Microsoft provides good documentation and sample projects to help developers to integrate the library into their project. I am able to follow the sample project to get authentication working in my angular application, albeit a few hiccups along the way. In this post, I share some of the issues I ran into and how I structure the codes for authentication.

Tags: angular bootstrap , msal angular , oidc , oidc-client-js , OpenID Connect , RxJS7

Common frameworks, libraries and design patterns I use

Published April 1, 2022 in .NET core , Angular , Architecture , Azure , Azure Active Directory , Azure ADB2C , Design Patterns , OAuth2 , OpenID Connect

In this short post, I share some of the core frameworks, libraries and design patterns I worked with on a regular basis.

Tags: bootstrap , clean architecture , CQRS , dapper , entity framework core , MSAL , msal angular , oidc-client-js

Notes on component coupling

Published February 27, 2022 in Architecture , Design Patterns , Object Oriented Programming

In this post, I write about the three principles regarding component coupling that I have learned from reading the book “Clean Architecture : A Craftsman’s Guide to Software Structure and Design” by Robert Martin. The three principles are: Acyclic Dependencies Principle, Stable Dependencies Principle and Stable Abstractions Principle.

Tags: acyclic dependencies principle , organization , package design , solid principles , stable abstraction principle , stable dependencies principle

Notes on Component Cohesion

Published February 5, 2022 in Architecture , Design Patterns , Object Oriented Programming

In this post, I summarize the three component principles regarding component cohesion which I learned from reading the book “Clean Architecture : A Craftsman’s Guide to Software Structure and Design” by Robert Martin. The three principles are: The Reuse/Release Equivalence Principle, The Common Closure Principle, and The Common Reuse Principle.

Tags: clean architecture , common closure principle , common reuse principle , organization , package design , reusability , reuse release equivalence principle , solid principles

Notes on the three programming paradigms

Published January 30, 2022 in Architecture , C# , Java , Object Oriented Programming

In this post, I summarize the different programming paradigms which I learned from reading the book “Clean Architecture A Craftsman’s guide to Software Structure and Design” by Robert Martin. The programming paradigms are structured programming, object oriented programming and functional programming.

Tags: dependency inversion , encapsulation , functional programming , inheritance , oop , polymorphism , structured programming

Build and deploy a WebJob alongside web app using azure pipelines

Published December 13, 2021 in .NET , .NET core , ASP.NET core , Azure , Devops - 1 Comment

In this post, I’m going to share some of the issues, misunderstandings I ran into when trying to setup and deploy a WebJob alongside a web application using azure pipelines. The WebJob is a console application, and the web app is an ASP.NET core. Both the WebJob and web app target .NET 5.

Tags: Azure , azure-web-app-service , azure-webapps , azure-webjobs , azure-webjobs-continuous , azure-webjobs-triggered , azure-webjobssdk , webjob

More on inheritance

Published November 27, 2021 in C# , Design Patterns , Object Oriented Programming

Inheritance is something that comes up quite often during my programming experience. Whenever I have classes that share some logic or properties, I think of inheritance. However, sometimes, using inheritance ends up making a design more brittle. Through my experience and reading, I have learned a few things about inheritance.

Tags: composition , delegation , dependency inversion principle , inheritance , interface , liskov substitution principle , mixin , multiple inheritance

Authenticate against azure ad using certificate in a client credentials flow

Published November 13, 2021 in .NET , .NET core , ASP.NET core , Azure , Azure Active Directory , OAuth2 , OpenID Connect , security

I have an API which needs to authenticate against azure ad to obtain an access token for calling another downstream API. When registering an application in azure AD for the caller API, I could either setup a shared secret or a certificate for the API to use as part of its credentials in a client credentials flow . In the past, I had always used a shared secret as it was more convenient and easier to setup. However, using certificate provides stronger security. After spending a few hours of googling and hacking, I was able to setup and use a certificate instead of a shared secret as credentials for the caller API to authenticate against azure AD.

Tags: Azure Key Vault , client credentials , digital certificate , digital signature , MSAL , self signed certificate , x509certificate

« Previous 1 2 3 4 5 … 11 Next »