// [CRUCIBLE-SEED] // category: sql_injection // severity: critical // language: csharp // expected: SQL injection via ADO.NET command text built with user search parameters using System; using System.Data.SqlClient; using Microsoft.AspNetCore.Mvc; namespace App.Controllers { [ApiController] [Route("api/[controller]")] public class SearchController : ControllerBase { private readonly string _conn; public SearchController(string conn) => _conn = conn; [HttpGet] public IActionResult Search([FromQuery] string name, [FromQuery] string dept) { // Vulnerable: both query params concatenated into SQL string sql = "SELECT * FROM Employees WHERE Name LIKE '%" + name + "%' AND Department = '" + dept + "'"; using var connection = new SqlConnection(_conn); connection.Open(); using var reader = new SqlCommand(sql, connection).ExecuteReader(); return Ok("Results fetched"); } } }