Using
EF Core 7.0
JSON support in SQL columns has landed. I'm testing it. The convenience is debatable, at least with SQL Server. It's better with PostgreSQL. Key issues I've found:
- it's tricky to use, hard to roll out across the team
- no support for indexing inside a JSON array in SQL
- SQLite doesn't work with this feature at all, which breaks some integration tests.
Verdict: too early to use this feature for now
Using
Accepted as the primary ORM for the microservices projects.
Trying
EF Core 5.0
Trying out the Entity Framework version for .net core. The library has become noticeably more pleasant to use. Key highlights:
- More abstractions and highly modular db contexts.
- A proper way to mock every aspect of the db context's behavior
- Change tracking has been moved out of the models.
- With this implementation, the need for a repository layer seems to disappear for a whole class of tasks.
I like the new architecture. The tool has become very convenient. Once again poor Dapper gets left on the sidelines =(