LINQ Queries

LINQ queries demonstrate how to operate and query the Snowflake objects wrapped in an Entity Framework data model. Listed below are some examples of LINQ queries supported by the Entity framework. In the following example, it is used CallCenter.cs file to map the CallCenter Datatable.

Select and Filter

Retrieve records from the CALL_CENTER table where the CC_CALL_CENTER_SK is "1.

C#	Copy Code
var records = from p in context.CallCenters where p.CcCallCenterSk == 1 select new { p.CcCallCenterSk, p.CcName, p.CcClass };

Contains

Retrieve records from the CALL_CENTER table where the cc_class property contains the substring "large".

C#	Copy Code
var records = context.CallCenters.Where(x => x.CcClass.Contains("large"));

Limit

Retrieve the first 10 records from the CALL_CENTER table.

C#	Copy Code
var records = (from p in context.CallCenters select p).Take(10); //taking 10 records

Order by

Retrieve all records from the CALL_CENTER table and sort them in descending order based on the cc_class property.

C#	Copy Code
var records = (from p in context.CallCenters orderby p.CcCallCenterSk descending//Implementing Order By select p);

Count

Count all entities that match a given criterion.

C#	Copy Code
Query based on the number of records selected

Group By

Group records from the CALL_CENTER table based on the cc_class property. The groups are then ordered in descending order based on the cc_class.

Copy Code

var sampleTable = context.CallCenters.AsEnumerable();
var queryCreatedBy = from b in sampleTable
                     group b by b.CcClass into newGroup //Linq Group Query based on CcClass 
                     orderby newGroup.Key descending
                     select newGroup;