PostgreSQL in C# .NET with Npgsql, Dapper, and Entity Framework: The Complete Guide

One of the most used databases these days is PostgreSQL (aka Postgres). Its accomplishments include being the most popular DB [among professional developers] according to Stack Overflow survey of 2022, the database in all of the fastest TechEmpower benchmarks, and being the most advanced open source database (self-proclaimed). We’ll talk today about combining Postgres with my favorite language and runtime: C# and .NET. Just because Postgres isn’t a first-party Microsoft database, like SQL Server, doesn’t mean you don’t have full support for it in C#.

Creating a Database in C#: Interviewing the CEO of RavenDB Oren Eini

Oren certainly makes a unique impression. Having listened to a lot of CEO interviews in countless podcast episodes, I never encountered another CEO more knowledgeable about the intricacies of C# than Oren. As we sidetracked into his many adventures in developing a database, Oren’s talked about .NET garbage collection, ...

6 Hidden Productivity Gems in Resharper and Rider

Six productivity tips when using ReSharper or Rider

What I Learned About C# From Job Interviews

After going through a bunch of code interviews, here's some things I learned from coding problems that I never use in my day-to-day.

Dynamic Queries with Expressions Trees in C#

In this article, you'll see how frameworks like Entity Framework and MongoDB C# driver use expressions trees to make that conversion. And you'll see how to use expression trees yourself to build dynamic queries. Those are queries that you aren't able to create at compile time because you'll know how the query should look like only at runtime.

Assembly Versioning and DLL Hell in C# .NET Framework: Problems and Solutions

In this article, we'll talk about what exactly is DLL Hell, how these kinds of problems can occur, and the best ways to dealing with them.

Understanding How Assemblies Load in C# .NET

We are constantly dealing with libraries and NuGet packages. These libraries depend on other popular libraries and there are a lot of shared dependencies. With a large enough web of dependencies, you'll eventually get into conflicts or hard situations. The best way to deal with such issues is to understand how the mechanism works internally.

Is C# Slower Than C++?

Is C# slower than C++? That's a pretty big question. As a junior developer, I was sure that the answer is "Yes, definitely". Now that I'm more experienced, I know that this question is not obvious and even quite complicated.

C# to C# Communication: REST, gRPC and everything in between

There are many ways to communicate between a C# client and a C# server. Some are robust, others not so much. Some are very fast, others aren't. It's important to know the different options so you can decide what's best for you.