Recently we have a requirement for one project where the ID for any entities in this project must be within a range of number. In this project, we have to integrate with a number of other external parties. The ID for any entity used in this integration must be unique globally across all the connected … [Read more…]
In this post, I’m going to show how to insert, update or delete a single item from a nested collection property in DynamoDB. Let’s say we have a document like this. One way (somewhat obvious?) to update, insert or delete a particular book from this document is to retrieve the whole document, mutate the data … [Read more…]
In this previous post, I showed how to update a property in a nested object in DynamoDb. In that post, the property was a simple string. In this short post, I’m going to show how to update an object property. Let’s say our DynamoDB document looks like this We can use UpdateItemAsync to update only … [Read more…]
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…]