Plugin - Which query to use - fetchxml or Linq?

(0) Share

Report

Posted on by Seamus

1,577

Hello,

I am seeking some advice. - I am writing a CRM (Dynamics365 online) Plugin on pre-Create of a Lead.

Central to this is a (retrievemultiple) query to find out if leads already exist in CRM with the same details (email, name) as the incoming Lead.

I will then use attribute-values from the entities in this resultset in order to update the new/incoming Lead.

In terms of speed/efficiency, future-proofing and (less-so) ease of use, would you recommend I use fetchxml for this query, or Linq, or any other alternative?

Also, am I better to use late or early-binding - is there any performance advantage in either?

Many thanks for advice.

- Seamus

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Ram Prakash Duraisamy 2,287 on at

Like (0)

Report

Hi Seamus,

Please find the performance order which we can use for Retrieve Multiple

1.QueryExpression

2.Linq

3.Fetchxml

Was this reply helpful? Yes No
Seamus 1,577 on at

Like (0)

Report

Thanks Ramprakash. So, fetchxml is the "worst"? Any advice of later or early binding, or is there no difference?

Was this reply helpful? Yes No
Verified answer

Charles Abi Khirs 3,569 on at

Like (1)

Report

Hello,

I don't think there is better statement than the other, because they are all reflected as SQL statements on the database level. However, the way you write your query and what you want to achieve with it might impact the performance, like aggregation, retrieving all columns instead of only the needed ones, or not using linked entities when needed.

As for early bound and late bound, it doesn't impact the performance because it is a way of writing the code where I prefer to use early bound because it gives you the intellisence and you can avoid the typo errors that can be present in using late bound.

Was this reply helpful? Yes No