In my current project, I have to implement a search functionality where users can provide a search term and the search term is to be matched exactly. This also means that any leading and trailing in the search term must be respected. Let’s say we have these Posts in the database And we initialise the … [Read more…]
We had upgraded to EF Core 6.0 for a while now but we haven’t had any schema change with migrations since before the upgrade. One of the recent changes had a migration and we noticed that the migration was never run. We tested other projects that also had upgraded to EF Core 6.0 and they … [Read more…]
Recently, a friend of mine asked me if there’s a better way to run integration tests without using in-memory DB because in-memory DB does not behave exactly like the real thing. In my opinion, the repository should be simple and not contain any business logic. Hence mocking the data in the in-memory DB for the … [Read more…]
I have a class with a complex object property that has a lot of properties and a lot of nested complex properties in it. Other properties in this class will be stored in SQL the normal way, relational and one column per property. Given the complexity of this particular property, I want to store it … [Read more…]
In relational databases like SQL, you can load related entities using Joins. In case of one-to-many relationships, this would lead to duplicated data returned. For example, entity Book has one-to-many Comments. If a book has 3 comments, the query below will return 3 rows, one for each comment with duplicate data for the book. Now … [Read more…]
In this previous post, I showed how to execute raw SQL query using EF but it requires the entity to be defined and to be accessible via DbSet. However, there might be times where you just want to execute a raw SQL query to return some arbitrary shape that is not necessarily part of your … [Read more…]
I came across a problem with EnsureCreated() method that broke all the SQL migrations on start up. I have some queries that I wanted to run before the migrations. I thought I should make sure the database exists before I run them. I saw the method DatabaseFacade. EnsureCreated() and decided to use it. This method … [Read more…]
In the last post, I showed how we use SQL Sequence to achieve sequential number ID in a specific range. As mentioned in the last post, we and each party that we integrate with have a defined range of number to be used as ID and this ID must be unique globally among all the … [Read more…]
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 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…]