Queryable PostgreSQL arrays in EF Core 8.0
Queryable collections?
Posts by Year
2023
2021
When “UTC everywhere” isn’t enough - storing time zones in PostgreSQL and SQL Server
When “UTC everywhere” isn’t enough
Mapping .NET Timestamps to PostgreSQL
INTERESTED IN TIMESTAMPS? SEE ALSO When “UTC everywhere” isn’t enough - storing time zones in PostgreSQL and SQL Server
Query parameters, batching and SQL rewriting
In the upcoming version 6.0 of the Npgsql PostgreSQL driver for .NET, we implemented what I think of as “raw mode” (#3852). In a nutshell, this means that yo...
EF Core 6.7 Update Performance Improvements
For the 7.0.0-preview6 release of Entity Framework Core, I wrote a blog post about the update pipline performance improvements introduced into EF Core 7.
EF Core 6.0 Performance Improvements
For the 6.0.0-preview4 release of Entity Framework Core, I wrote a blog post about the performance improvements introduced into EF Core 6.
2020
The Curious Case of Commands and Cancellation
Async brought a world of goodness (and complexity) to .NET, including the concept of cancellation: since async operations are by their nature supposed to tak...
C# 8 Nullable Reference Types, old TFMs and Multitargeting
C# 8.0 finally brought us nullable reference types (NRTs), which us to annotate our reference types as non-nullable and get compiler warnings for code that m...
2019
Conceptual and API documentation with Docfx, Github Actions and Github Pages
A good software project is (among other things!) measured by the quality of its documentation, but setting up a good documentation workflow isn’t trivial. Th...
EFCore 3.0 for PostgreSQL - Advanced JSON Support
JSON and Databases
2018
Npgsql 4.0 - A High Performance Database Driver
Npgsql 4.0 was finally released on May 30th, and as the release notes mention, a big focus of that release was making the driver as fast as it could be.
Support for new PostgreSQL 10 features
PostgreSQL 10 added a ton of exciting new features which everyone should look at. Npgsql and the EF Core provider have been updated to support those features...
2017
Prepared Statements, Connection Pooling and Npgsql 3.2
Prepare Thy Statements
2016
Entity Framework Core and Cross-Database Support
A post of mine just got published on the Microsoft MVP blog, about how Entity Framework Core allows exposing database-specific features in ways not possible ...
Project and Package References in the new csproj format
Microsoft has recently released the new version of the build tools for .NET Core. As previously announced, the new build system will be MSBuild-based (oh pro...
2015
New things happening with logging at Microsoft
Since the last time I wrote about logging, Microsoft appears to be working on something totally new as part of ASP.NET vNext.
2014
Roslyn and Aspect-Oriented Programming
Microsoft has recently announced open-sourcing .NET Core, which will eventually lead to open-sourcing the entire .NET Framework. The next version of .NET, wh...
The nightmare that is logging from libraries (in .NET)
One developer’s adventures trying to sanely log from a third-party .NET library