LINQ Guide - Overview
This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.
Most applications are currently written on top of relational databases. At some point, these applications will have to interact with the data represented in a relational form. Database schemas are not always ideal for building applications, and the conceptual models of applications differ from the logical models of databases. The Telerik Data Access Domain Model is a conceptual domain model that can be used to model the data of a particular domain so that applications can interact with data as objects.
Through the domain model, Telerik Data Access exposes entities as objects in the .NET environment. This makes the object layer an ideal target for Language-Integrated Query (LINQ) support. Therefore Telerik Data Access includes LINQ to OpenAccessContext support. It enables developers to write queries against the database from the same language used to build the business logic.
The following topics show how to query a domain model by using Language-Integrated Queries (LINQ):
- How to: Execute a Query that Returns a Data Type
- How to: Execute a Parameterized Query
- How to: Navigate Relationships Using Navigation Properties
- How to: Return a Single Object
- How to: Filter Data
- How to: Sort Data
- How to: Group Data
- How to: Aggregate Data
- How to: Execute a Query that Returns an Anonymous Type
- How to: Execute a Query that Returns a Primitive Type
- How to: Return a Specific Object Using its Key
- How to: Order Two Unionized Queries
- How to: Page Through Query Results
- How to: Remove Duplicate Elements
- How to: Convert the Results of a LINQ Query to an Array
- How to: Execute a Query Using a Stored Procedure
- LINQ Expressions
- How to: Retrieve Objects Based on Values Contained in an In-memory Collection