Shay Rojansky's Blog

Shay Rojansky

Microsoft software engineer working on .NET data access and perf, member of the Entity Framework team. Lead dev of Npgsql, the PostgreSQL provider.

When “UTC everywhere” isn’t enough - storing time zones in PostgreSQL and SQL Server

8 minute read

When “UTC everywhere” isn’t enough

Mapping .NET Timestamps to PostgreSQL

9 minute read

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

7 minute read

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.0 Performance Improvements

less than 1 minute read

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.

The Curious Case of Commands and Cancellation

4 minute read

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...