#C#
Posts tagged with this topic.
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...
Jan 19, 2025
This is another benchmark blog post, in which I tried to upgrade the greatest snippet on how to do bulk insert, update, or delete (blog post by Mark Carrington that you can read here) with the async operation. As you know, the latest Dataverse ServiceClient supports async...
Jan 11, 2025
Quick tips for those who want to retrieve data using QueryExpression, join it with multiple tables, and filter it using OR condition based on LinkEntities. To simplify the explanation, let me show the SQL Query that we want to achieve for the scenario: SELECT contact.firstname,...
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...
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...
Nov 3, 2024
Currently, I'm still focusing on how to improve bulk processing in Dataverse. After implementing User Multiplexing, we will learn another consideration that we can apply which is the total threads and chunks of data per thread. Of course, some variables such as network speed,...
Oct 5, 2024
Last week, we learned that bulk operation messages offer higher performance than ExecuteMultipleRequest. Today, we dig deeper with the sample of scenarios that I prepared so you can understand when you need to use ExecuteMultipleRequest vs bulk operation messages. Enjoy!...
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...
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...
Aug 17, 2024
Based on part 1 which you can read here, I realized that creating a plugin to automate the approval process will be easier compared to creating Power Automate Flow. The main reason is, that if we need to use Flow, then we need to create multiple connection reference components...