OrganizationServiceContext.CreateQuery vs Fetch

Question

Hoping someone can shed some light in terms of performance when using OrganizationServiceContext.CreateQueryvs with FetchXML(or QueryExpression).

I have widely used LINQ, but new to CRM. CreateQueryseems appropriate for my skill set, but I think of performance in the end.

I understand that straight up

var result = from e in orgContext.CreateQuery("xyz_myentity")
             where e["email"] == "[e-mail]"
             select e;

will return all attributes for xyz_myentity, but I can not find any documentation for the LINQ provider, which is on top of CRM. Will I use anonymous constraint attributes returned from SQL / CRM? Or is the magic done by the "client" side after the full data set is returned from the server? Is the SQL query for all attributes and then the LINQ provider creating an anonymous type on top of this?

var result = from e in orgContext.CreateQuery("xyz_myentity")
             where e["email"] == "[e-mail]"
             select new { Name=e["xyz_name"] };

Are there any other considerations related to the introduction OrganizationServiceContext?

Answer 1

LINQ CRM QueryExpression . Microsoft.Xrm.Sdk. QueryExpression - CRM.

LINQ (LINQ → QueryExpression → SQL), .

FetchXML - , CRM. Microsoft , . FetchXml XML-, .

OrganizationServiceContext LINQ; , . , , , , . . .

LINQ QueryExpression, - . , CRM .

(: CRM 2016 -API.)