Azure-docs: Need clarification about whether it's PARAMETERIZED SQL that LINQ translates to?

[HuaTang92]

[Enter feedback here]
Hi team,

Could we clarify when LINQ transits to SQL, whether it's PARAMETERIZED SQL that it translates to?
And if possible, could we add comparison between LINQ-to-SQL and Parametrized SQL?

Thanks,
Hua

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 7af26f57-f473-916a-bd4d-0918ef9eefcd
• Version Independent ID: b553182a-4d34-96d6-219e-1abbd031c642
• Content: LINQ to SQL translation in Azure Cosmos DB
• Content Source: articles/cosmos-db/sql-query-linq-to-sql.md
• Service: cosmos-db
• GitHub Login: @timsander1
• Microsoft Alias: tisande

[NavtejSaini-MSFT]

@HuaTang92 We are checking this and we will get back to you.

[NavtejSaini-MSFT]

@timsander1 Please check this and provide insight into the same.

[aliuy]

You can append toString() on the IQueryable generated by the LINQ Provider to examine how the query is passed to the service. Reference: https://stackoverflow.com/questions/41023747/how-can-i-trace-the-query-produced-by-the-documentdb-linq-provider

In this case - the LINQ Provider escapes the parameterized input as opposed to delegating this downstream.

[NavtejSaini-MSFT]

@HuaTang92 Please let us know if you have any other question or we will go ahead and close the thread.

[SnehaGunda]

I made a minor doc update to add the ToString information.