.NET developer blog

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

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

« Previous 1 2 3 4 5 … 11 Next »