.NET

Posts in this category.

Dataverse: Benchmark ExecuteMultiple Request SDK vs WebApi call

Mar 22, 2025

In the PowerApps-Samples repo, I found interesting sample code to execute Dataverse messages using WebAPIs call. For those who ask why there is this option, it is because not so many organizations let you install NuGet Packages freely without having risk analysis (the reason can...

Dataverse: Updated ServiceClient Strategy For Better Performance

Mar 9, 2025

If you remember, I created this blog post on how to create a class that wrapped ServiceClient. I must do it because instancing a ServiceClient is expensive (around 2 seconds). Hence, I need to find a way to "store" it in memory and ensure it is always ready when I need to call...

Setup Github Workflow to generate Dataverse Entity Classes

Jan 25, 2025

As a person who cherishes "Early-Bound" so much, I want to ensure my team also uses it in the project. The step to generate the "Early-Bound" is not too complicated, especially after Microsoft Power Platform CLI (pac modelbuilder build). But, again, enforcing it on other team...

Benchmark: Comparing Pooling Setting in TDS Endpoints

Dec 7, 2024

We must construct the SQL Connection String when connecting to Dataverse TDS Endpoints via .NET code. The structure of it by default is just "Server={orgname}.crm.dynamics.com;Database={orgname};Persist Security Info=False;". When we talk about SQL connection strings, there are...

Learn: Create Power Automate Custom Connector - API Key Authentication

Nov 24, 2024

Today we will learn how to create a Custom Connector from scratch and implement API Key Authentication. The authentication code that I used is the reference from the below YouTube video from Nick Chapsas: https://www.youtube.com/watch?v=GrJJXixjR8M Without further ado, let's...

Dataverse: ExecuteMultipleRequest vs CreateMultipleRequest Benchmark

Sep 28, 2024

This is another benchmark post; this time, we need to compare ExecuteMultipleRequest vs CreateMultipleRequest. For those who don't know ExecuteMultipleRequest allows us to basically mix operations (Create, Update, or Delete) and pass parameters to control if an error is raised...

Dataverse: Create ServiceClient Strategy

Sep 15, 2024

I just realized creating ServiceClient is an expensive operation (I found one blog post that confirmed this problem even though this was an article from 2017). During one of the API call tests, almost half of the time was wasted on the creation of ServiceClient. Before, I always...

Dataverse: Create Custom Integration To Azure Cosmos DB for PostgreSQL

Jul 20, 2024

In a world where integration is common to do. Especially, because clouds is a common term, for sure, there are requests to integrate Dataverse with another DB (for reporting, or other system process purposes). Today, we will learn how to create Dataverse Plugins to do CUD...

(Dataverse) .NET API Implement Multiplexing Strategy

Jul 5, 2024

In some scenarios, we sometimes need to add a middleware (in this case .NET WebAPI) that connects Dataverse to other applications for integration. The reason can vary such as making the connection, request, and response to Dataverse simpler. If the integration loads are high and...