LINQ クエリ

LINQ queries demonstrate how to operate and query the Salesforce objects wrapped in an Entity Framework data model. Listed below are some examples of LINQ queries supported by the Entity framework.

Select and Filter

Retrieve records from the Order table where the BillingState is "Delhi".

C#	コードのコピー
var records = from p in context.Order where p.BillingState == "Delhi" select p;

Contains

Retrieve records from the Order table where the AccountId property contains the letter "A" in its value.

C#	コードのコピー
var records = from p in context.Order where p.AccountId.Contains("A") //Contains を使用して、A を持つ AccountId を表示します。 select p;

Limit

Retrieve the first 10 records from the Order table.

C#	コードのコピー
var records = (from p in context.Order select p).Take(10); // レコードを10 件取得します。

Order by

Retrieve all records from the Order table and sorts them in descending order based on the AccountId property.

C#	コードのコピー
var records = (from p in context.Order orderby p.AccountId descending//Order Byの実装。 select p).Take(10); // レコードを10 件取得します。

Count

Count all entities that match a given criterion.

C#	コードのコピー
var _count = (from p in context.Order select p).Count();//選択されたレコードの数に基づいてクエリをカウントします。

Group By

Group records from the Order table based on the BillingCity property.

C#	コードのコピー
var ordersTable = context.Order.AsEnumerable(); var queryOrders = from b in ordersTable group b by b.BillingCity into newGroup orderby newGroup.Key descending select newGroup;

Joins

Cross join between the Status and BillingState tables.

C#	コードのコピー
var records = from b in context.Status from e in context.BillingState select new { b, e };//クロス結合を定義します。