How Dapper's String Parameter Handling Can Defeat SQL Server Index Performance
If you're using Dapper with anonymous objects to query varchar columns, you're probably sending nvarchar(4000) parameters — causing CONVERT_IMPLICIT on every row and defeating your indexes. Here's…
Read the full articleYou might also wanna read
C#: Easy CRUD for your Web API with Dapper
Full disclosure here: I don’t like ORMs. If you’re building an enormous enterprise project, you should absolutely use an ORM. If you have da
Getting started with query parameterization
In this hands-on article, we’ll review how to leverage SQL query parameterization and stored procedures to prevent injection attacks, as wel
SQL Basics: Keywords, Data Types, and Operators Explained for Beginners
A technical guide published on DEV Community covers the foundational building blocks of SQL, including reserved keywords, data types, and op
PHP package compiles DTO hydration closures to hit 4.5M operations per second
A new PHP 8.4+ package called Simple Data Objects eliminates the performance overhead typically associated with attribute-driven Data Transf
CVE-2026-15736: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') in Snowflake Snowflake SQLAlchemy
Snowflake SQLAlchemy versions prior to 1.11.0 contain multiple SQL injection vulnerabilities and a local file exposure issue. These include
Automatically Generate POCOs From DB With T4
The T4 template engine is insanely powerful. I didn’t really realize just how powerful it was until I had a use case for it today. I stood u
Comments
Sign in to join the conversation.
No comments yet. Be the first.