35
Hello
I am using Microsoft CRM 2011 SDK and I'm trying to replace some SQL selects with relative SDK QueryExpression.
The question is: in C# language how can I convert this follow query?
select *
from dbo.salesorder as a
where name like '%TEST%'
OR (select b.accountnumber from dbo.account as b where b.accountid = a.customerid) like '%TEST'
I'll await an answer. Thank you very much!!!
Best regards
Matteo
Hi Matteo Veggiari,
There is no any direct way to convert SQL to query expression. Please refer below url to create query expression using like operator.
Hello Matteo,
Are you looking for the code to convert SQL to QueryExpression or the QueryExpression itself?
If first - I'm afraid that's not doable.
If you are looking for Query alone I would recommend to use FetchQuery instead and use following FetchXml Query
Share
Report
All responses (
Answers (
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156