DatabaseConnection.Query Method (IDatabaseConnection, ISqlQuery)

DatabaseConnectionQuery Method (IDatabaseConnection, ISqlQuery)

Compiles a SQL query, returning the an IEnumerableT of rows in the result set.

Namespace: SQLitePCL.pretty.Orm
Assembly: SQLitePCL.pretty.Orm (in SQLitePCL.pretty.Orm.dll) Version: 1.0.0.0 (1.0.0)

Syntax

Copy

public static IEnumerable<IReadOnlyList<IResultSetValue>> Query(
	this IDatabaseConnection This,
	ISqlQuery query
)

[<ExtensionAttribute>]
static member Query : 
        This : IDatabaseConnection * 
        query : ISqlQuery -> IEnumerable<IReadOnlyList<IResultSetValue>>

Parameters

This: Type: SQLitePCL.prettyIDatabaseConnection
The database connection.
query: Type: SQLitePCL.pretty.Orm.SqlISqlQuery
The SQL statement to compile and Query.

Return Value

Type: IEnumerableIReadOnlyListIResultSetValue
An IEnumerableT of rows in the result set.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type IDatabaseConnection. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Reference

DatabaseConnection Class

Query Overload

SQLitePCL.pretty.Orm Namespace