rmauro.dev {blog} | Yet Another Developer Blog

rmauro.dev {blog}

Oracle ODP.NET with truly Async Methods in C#

Oracle ODP.NET with truly Async Methods in C#

Oracle's ODP.NET 23c Dev (or Oracle.ManagedDataAccess.Core) release brings genuine async/asynchronous methods to support to database interactions in C#, revolutionizing the way developers work with Oracle databases. Under PreRelease until today : 2023-08-24 Async/Await in C# Before delving into the specifics of ODP.NET 23c Dev for

Oracle PIVOT Command - Turn Rows into Columns

oracle Featured

Oracle PIVOT Command - Turn Rows into Columns

Discover the technical prowess of Oracle's PIVOT command, a robust feature that efficiently converts rows into columns. This blog post delves into the syntax, use cases, and practical examples to illustrate how PIVOT simplifies data analysis and reporting in Oracle databases. Understanding the PIVOT Command The PIVOT command is an

C# Get JWT Token from Request .NET 6

C# Get JWT Token from Request .NET 6

This blog post will explore extracting a JWT token from incoming requests using C#. How to Get JWT Token from Request using C#

Oracle JSON_TABLE Transforming JSON into Table

oracle Featured

Oracle JSON_TABLE Transforming JSON into Table

The function JSON_TABLE allows us to transform JSON data into a table relational format. This article will explore the Oracle JSON_TABLE function and its syntax and provide examples to demonstrate its usage and capabilities.

Oracle MERGE Statement SQL

Oracle MERGE Statement SQL

Oracle MERGE statement is one of those powerful commands which allows you to perform INSERT and UPDATE operations in a single statement based on specific conditions.

XGH / eXtreme Go Horse

XGH / eXtreme Go Horse

I think therefore it's not XGH. In XGH you don't think, you do the first thing that comes to your mind. There's not a second option as the first one is faster.

C# JWT Authentication .NET 6

C# JWT Authentication .NET 6

In this article, we will work on implementing C# JWT Authentication using .NET 7 - which also works for .NET 6, and preview .NET 8 - using ASP.NET Core.

DALL-E Art-Generator with C# .NET

DALL-E Art-Generator with C# .NET

In this blog post, we will explore the steps to develop a C# application using DALL-E model to generate images from text.

Getting Started with Serilog Custom Enrichers

Getting Started with Serilog Custom Enrichers

One of the key features of Serilog is the ability to Enrich Log Events with additional contextual information that can help in troubleshooting and debugging. In this blog post, we will explore how to create a Custom Enricher with Serilog to add custom properties to log events.

Getting Started with Chat GPT integration in a .NET C# Console Application

ChatGPT Featured

Getting Started with Chat GPT integration in a .NET C# Console Application

With the use of C#, we can develop a console application that uses the Chat GPT model to generate human-like responses to input.

EMC square formula

Define Implicit and Explicit Operator - C# Tips

C# allows us to define Implicit and Explicit operators. Unlike casting Implicit and Explicit operators defines how C# should behave when encountering an equals sign. Implicit operator execution can be invoked when assigning a variable or calling a method. To use Explicit operator we should do the same as casting

Digital Clock on the wall

Calculate Time Ago with .NET C#

Here is a small extension method over System.DateTime that gives its relative time readable for humans, such as: * one minute ago * 2 minutes ago * one hour ago * 3 hours ago * 3 days ago Check out this extension method over the DateTime structure using switch patterns. public static string AsTimeAgo(

SSH Exposed to Internet - 8 steps check list

Exposing virtual machines to the internet it's not an easy task. Often managed using an SSH connection we must secure our machines as much as we can against hacker attacks. Let's go through some often and ease configurations that will make it an attacker hard if trying to access your

Create a Minimal API with .NET 6

Create a Minimal API with .NET 6

One of the new features of .NET 6 is the arrival of a new template, which will replace the default and bring a good reduction in code writing. Including the removal of the Startup.cs file. .NET 6 was released as LTS (long-term stable) which means support for 3 years.

Set up Serilog in .NET 6 as a logging provider

Set up Serilog in .NET 6 as a logging provider

Let's set up Serilog as Logging Provider in the native logging system in .NET so you can use the Microsoft ILogger interface.

Optimizing Query Performance on C# ODP.NET - Oracle Managed Data Access

Optimizing Query Performance on C# ODP.NET - Oracle Managed Data Access

Oracle C# drive is already pretty fast with the default configuration. But we can always tweak it a little to make it even faster. By controlling the FetchSize property in ODP.NET we can make fewer round trips to Oracle Database and fetch the data faster. Let's take a look

Adding Startup.cs back to .NET 6 Project

Adding Startup.cs back to .NET 6 Project

When .NET 6 was released, the first big change was the lack of Startup.cs. This is very nice and all. But sometimes we just want it back, and here is how. First, create a new file called Startup.cs at the root of your project with the following content

Oracle Database on Docker for Development

Oracle Database on Docker for Development

Lets set up an Oracle Database instance for development purpose using Docker is very easy. And it also runs in WSL2 over Windows. Let's use the oracleinanutshell/oracle-xe-11g image.

AZ-900 - Useful Resources for the Exam

AZ-900 - Useful Resources for the Exam

Azure Fundamentals exam is an opportunity to prove knowledge of cloud concepts, Azure services, Azure workloads, security and privacy in Azure, as well as Azure pricing and support. Candidates should be familiar with the general technology concepts, including concepts of networking, storage, compute, application support, and application development. Here are

Health Checks on your ASP.NET Core Application

DotNet Featured

Health Checks on your ASP.NET Core Application

Health Endpoint Monitoring pattern Health Check in .NET 5 is very simple. With just a few lines of code, you can set up everything to monitor the Health of our Application. Implement functional checks in an application that external tools can access through exposed endpoints at regular intervals. This can

Clock Representing the Time

DotNet Featured

Add Build Time to your C# Assembly

Having the Assembly version is great. This give us insights of wich version is running. Have the build time can also useful. Specially when we're troubleshooting our application and we're not sure of which version is running. For instance besides having only the assembly version we can have the version

Create a free MongoDb Cluster in the Cloud - Mongo Atlas free account

MongoDb Featured

Create a free MongoDb Cluster in the Cloud - Mongo Atlas free account

MongoDB is a document-oriented NoSQL database used for high volume data storage. Instead of using tables and rows as in the traditional relational databases, MongoDB makes use of collections and documents. MongoDb is very easy to get started - That is why I love MongoDb. I think it's the best

API Key Authentication - Extending the native implementation

.NET 5 Featured

API Key Authentication - Extending the native implementation

In this article, we're going to create the code (and understand how it works) to handle API Key authentication with just three lines of code extending the native Authentication mechanism. We want a simple and stupid solution and not some crazy implementation using MVC [Attributes] or any customized middleware to

charts indicating monitoring

Endpoint Monitoring with Azure Application Insights

Let's explore the use of Microsoft Azure Application Insights to monitor the health of our application using the endpoint /healthcheck. Applications Insights it's a great tool for monitoring, error logging, performance monitoring, dependency mapping, and other things. In other words, it's a full APM - Application Performance Management - ready