After years of building transactional systems with .NET and PostgreSQL, I've learned that ORMs are fantastic tools—until they're not. Let me share what I've discovered about optimizing database ...
Community driven content discussing all aspects of software development from DevOps to design patterns. These practice questions help address commonly misunderstood AZ-204 concepts. If you can answer ...
Ok, I'm going to do a review of this article, which is the subject of my long-term interest. Link will be in comments below. PostgreSQL functions are powerful tools that allow developers to ...
Microsoft is making a big push to publicize its new .NET Aspire tech stack for streamlining the development of .NET cloud-native services. The company unveiled .NET Aspire at last month's Build 2024 ...
Scatter-gather is an enterprise integration pattern where a single large operation is split into a number of sub-operations, usually performed by separate workers. Then, another operation must be ...
At the most basic level, Supabase is a Postgres database. As such, you can create a project, grab the .NET connection string, and use it as you would any other database. However, if you use the ...
First off, let’s create an ASP.NET Core 7 project in Visual Studio 2022. Follow these steps: We’ll use this ASP.NET Core 7 Web API project to work with advanced features of Dapper in the sections ...
Take advantage of stored procedures, query pagination, query caching, and other advanced Dapper feature to simplify data access and ensure high performance. The Dapper ORM (object-relational mapper) ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Spencer Judge discusses the architectural ...