LINQ Guide - Overview
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 schemata are not always ideal for building applications, and the conceptual models of applications differ from the logical models of databases. A Telerik Data Access Model is a conceptual model of a given database that can be consumed by the applications when they interact with the data.
Through the 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 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