Description
Exaample:
string query = "SELECT * FROM Department WHERE DepartmentID = {0}";
|
var department = await _context.Departments
|
.FromSqlRaw(query, id)
|
.Include(d => d.Administrator)
|
.AsNoTracking()
|
.FirstOrDefaultAsync();
|
Generates invalid SQL++ query:
SELECT `c`.`departmentid`, `c`.`budget`, `c`.`instructorid`, `c`.`name`, `c`.`rowversion`, `c`.`startdate`
|
FROM (
|
SELECT * FROM Department WHERE DepartmentID = $p0
|
) AS `c`
|
LIMIT 1
|