Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Prevent SQL Injection with Parameterized Queries

- 04.07.26 - ErcanOPAK

🔒 Never Concatenate User Input into SQL

SQL injection is #1 web vulnerability. Parameterized queries prevent it. Always use parameters for user input.

❌ Vulnerable (SQL Injection)

string query = "SELECT * FROM users WHERE email = '" + email + "'";
var cmd = new SqlCommand(query, connection);
// User input: admin' OR '1'='1
// Query becomes: SELECT * FROM users WHERE email = 'admin' OR '1'='1'
// All users returned!

✅ Parameterized (Safe)

string query = "SELECT * FROM users WHERE email = @email";
var cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@email", email);
// Email treated as data, not code
// Safe from injection

🎯 Parameterized Queries Examples

// SQL Server
string query = "INSERT INTO Users (Name, Email) VALUES (@name, @email)";
using var cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@email", email);

// PostgreSQL (Npgsql)
string query = "INSERT INTO Users (Name, Email) VALUES (@name, @email)";
using var cmd = new NpgsqlCommand(query, connection);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@email", email);

// MySQL
string query = "INSERT INTO Users (Name, Email) VALUES (@name, @email)";
using var cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@email", email);

// Entity Framework (safe by default)
var user = await context.Users
    .Where(u => u.Email == email)
    .FirstOrDefaultAsync();

💡 Best Practices

  • Always use parameterized queries for user input
  • Use ORM (Entity Framework, Dapper) for safety
  • Validate and sanitize input
  • Use stored procedures with parameters
  • Regular security audits

“SQL injection is preventable. Parameterized queries are essential. Never concatenate user input into SQL.”

— Security Engineer

Related posts:

SQL: Optimizing Multiple WHERE Clauses with Index Intersection

SQL: Optimizing Multiple WHERE Clauses with Index Intersection

SQL Server: Fix a Parameterized Query Using a Bad Cached Execution Plan for Every Caller Because the...

SQL Server: Fix a Parameterized Query Using a Bad Cached Execution Plan for Every Caller Because the...

SQL Queries Slow Down After Indexing

SQL Queries Slow Down After Indexing

Views: 12

Post navigation

.NET Core: Serve Static Files (CSS, JS, Images)
C#: Implement IDisposable for Resource Cleanup

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com