Programmiererforum

if (country != null)
{
Query += " AND Users.Country IN (N'";

for (int i = 0; i < country.Count; i++)
{
Query += i == 0 ? $"@country{i}'" : $", @country{i}";
}

Query += ")";
}

context.Database.ExecuteSqlCommand(Query, new SqlParameter($"@country0", "de"));
< /code>
Dies ist der produzierte SQL: < /p>
exec sp_executesql N'INSERT INTO [table] (table.column1, table.column2)
SELECT 5002, table.column
FROM table2
LEFT OUTER JOIN table3 ON table2.column = table3.column
WHERE 1 = 1
AND table3.Country IN (N''@country0'')', N'@country0 nvarchar(2)', @country0 = N'de'
< /code>
Wenn ich die SQL manuell in < /p>
 ändere, ändere ich manuellexec sp_executesql N'INSERT INTO [table] (table.column1, table.column2)
SELECT 5002, table.column
FROM table2
LEFT OUTER JOIN table3 ON table2.column = table3.column
WHERE 1 = 1
AND table3.Country IN (N'de')', N'@country0 nvarchar(2)', @country0 = N'de'

Dies ist mein C# Code: < /p>
[code]if (country != null)
{
Query += " AND Users.Country IN (N'";

for (int i = 0; i < country.Count; i++)
{
Query += i == 0 ? $"@country{i}'" : $", @country{i}";
}

Query += ")";
}

context.Database.ExecuteSqlCommand(Query, new SqlParameter($"@country0", "de"));
< /code>
Dies ist der produzierte SQL: < /p>
exec sp_executesql N'INSERT INTO [table] (table.column1, table.column2)
SELECT 5002, table.column
FROM table2
LEFT OUTER JOIN table3 ON table2.column = table3.column
WHERE 1 = 1
AND table3.Country IN (N''@country0'')', N'@country0 nvarchar(2)', @country0 = N'de'
< /code>
Wenn ich die SQL manuell in < /p>
ändere, ändere ich manuellexec sp_executesql N'INSERT INTO [table] (table.column1, table.column2)
SELECT 5002, table.column
FROM table2
LEFT OUTER JOIN table3 ON table2.column = table3.column
WHERE 1 = 1
AND table3.Country IN (N'de')', N'@country0 nvarchar(2)', @country0 = N'de'
[/code]
Ich frage mich also, warum es das erwartete SQL nicht ersetzt/generiert. Name.