It’s common to have description attributes on Enum types. This allows adding a longer description string for each Enum value. In one of my recent projects, I have a Web API that needs to accept this description value from the JSON request body and map to the correct Enum value. In this post, I’m going … [Read more…]
In this previous post, I talked about how EF uses Update statements instead of Insert when adding new items with the item key populated to a list property of an object and then SaveChanges. In that post, the solution to get it working was to not populate the key property when adding the item to the list. EF … [Read more…]
I recently worked on building an automation testing framework for our testers to use. I decided to turn the framework into a generic solution that can be used to automate any website or API. In this post, I’m going to explain how the solution is structured, how it works and some of the concepts in … [Read more…]
When using Entity Framework, most people use LINQ-to-Entities to query the database. LINQ-to-Entities is easier and nicer to use than raw SQL. However, there are times you might want to use raw SQL instead, such as using an existing stored procedure, control the generated SQL for complex queries (LINQ-to-Entities can be very slow for complex … [Read more…]
In my recent project, I needed to update a single value in a nested object for a document on DynamoDB. In other projects, I would update the nested object property and then Save the whole document using SaveAsync from IDynamoDBContext. However, in this project, it needs to update the document from another microservice and I … [Read more…]
In this short post, I’m going to show how to get query value URL by key. Let’s say we have a sample URL like this. https://www.justsimplycode.com/fake/url?queryA=123&queryB=ABC There is this method ParseQueryString from HttpUtility, which can be imported from System.Web, that parses URL to a name value collection. This is the result One thing to watch … [Read more…]
The problem In one of our projects that uses EF Core, we have a one-to-many relationship model like this We need to build a new endpoint which allows users to update the blog as well as all its posts. When I review the pull request from my team member, the way he builds it is … [Read more…]
One of the micro services we have at work is responsible for converting HTML to PDF. We use wkhtmltopdf to convert HTML to PDF. In my opinion, it is not the nicest tool to use but it is open source and free. In this post, I will show how we use it. Firstly, we need … [Read more…]
In this previous post, I showed how to get Australian timezone name by state using Noda Time from UTC. In one of my recent tasks, I need to get the current date at 5pm local time to the user from an UTC date time in the format “yyyy-MM-ddTHH:mm:ss.fffK”. The user timezone is important here. The … [Read more…]
In one of the projects at work, I need to find certificate matching an email address from Firefox certificate manager if there is no matching certificate found in the Windows certificate store. In this post, I’m going to show how to find a certificate and export it from Firefox certificate manager. Firstly, let’s create a … [Read more…]