PostgreSQL Just Joined the FunkyORM Party
After a few decades of wrestling .NET data-access layers (and watching frameworks come and go), we at Funcular Labs still believe the best tool is the one you barely notice… the one that just works. That’s why we’re genuinely excited to announce full PostgreSQL support in Funcular.Data.Orm—better known around here as FunkyORM—now live in version 3.1.0.
You already know the drill if you’ve used our ORM with SQL Server: zero-configuration POCO mapping, lambda-powered LINQ queries that generate clean parameterized SQL, remote properties that flatten your object graphs without the N+1 tax, and performance that often leaves heavier ORMs in the dust. No DbContext boilerplate. No XML mapping files. Just your plain classes and the queries you’d write anyway.
Now the same delightful API works seamlessly with Postgres. Our new PostgreSqlOrmDataProvider (built on Npgsql) handles all the dialect differences transparently—double-quoted identifiers for reserved words, LIMIT/OFFSET paging, RETURNING clauses on inserts, native BOOLEAN columns… everything you’d expect. You can literally swap providers and keep your entity classes untouched (yes, even the ones with [RemoteProperty] and [RemoteKey] magic).
Whether you’re starting fresh or migrating an existing FunkyORM project, the experience is identical. And because we’re still the same lightweight micro-ORM at heart, you get the speed you love without giving up type safety or developer happiness.
Want to give it a spin? Head over to the NuGet package and pull in the latest bits: https://www.nuget.org/packages/Funcular.Data.Orm
We’d love for you to try it out on your next (or current) Postgres project. Drop the provider in, point it at your database, run a few queries… then swing by the comments and tell us how it feels. Did it save you time? Make your code cleaner? Surprise you in a good way? We read every note.
Here’s to simpler, faster data access—no matter which database you call home.