search

fish-404 / fish-404.github.io

blog
https://fish-404.github.io/
0 stars 0 forks source link

SQL - Query Plan & Parameterized SQL #12

Open fish-404 opened 2 years ago

fish-404 commented 2 years ago

Background:

Many applications I managed has string connected SQL methods. It's hard to read and debug and maintain. When I try out to find some better methods to write SQL in C#, find something more about this problem. It seems a topic which deserve to deep into.

  1. Concatenated SQL
  2. Parameterized SQL
  3. SQL Injection
  4. Query Plan
  5. Table-Valued Parameter (maybe a post)
fish-404 commented 2 years ago

Concatenated SQL & Parameterized SQL Reference:

fish-404 commented 2 years ago

Query Plan Reference: