DatabaseConnection.Query Method (IDatabaseConnection, ISqlQuery, Object[])

DatabaseConnectionQuery Method (IDatabaseConnection, ISqlQuery, Object)

Compiles a SQL statement with provided bind parameter values, 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,
	params Object[] values
)

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

Parameters

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

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