- 필수 기능
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- 디지털 경험
- 소프트웨어 제공
- 보안
- 로그 관리
- 관리
- 인프라스트럭처
- ci
- containers
- csm
- ndm
- otel_guides
- overview
- slos
- synthetics
- tests
- 워크플로
ID: csharp-security/sql-injection
Language: C#
Severity: Error
Category: Security
Never build SQL queries manually. Always have the query built with parameters and then pass the parameters to the prepared statement.
using System.Xml;
class MyClass {
public static void doQuery(Int32 userId)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SELECT attr FROM table WHERE id=" + userID, connection);
}
}
}
using System.Xml;
class MyClass {
public static void goQuery(Int32 userID)
{
String query1 = "SELECT attr FROM table WHERE id=" + userID;
}
}
using System.Xml;
class MyClass {
public static void doQuery(Int32 userID)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SELECT attr FROM table WHERE id=@ID", connection);
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters["@ID"].Value = userID;
}
}
}
|
|
For more information, please read the Code Analysis documentation
Identify code vulnerabilities directly in yourVS Code editor
Identify code vulnerabilities directly inJetBrains products