LINQ Support - 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 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 model is a conceptual model that can be used to model the data of a particular domain so that applications can interact with data as objects.
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.
This section provides conceptual information for programming with LINQ:
- Flow of Execution
- Types of Queries Against OpenAccessContext
- Standard LINQ Query Operators
- Query Execution
- Query Result
- Dynamic LINQ
- Using Database Functions
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