SQLiteConnectionDeferredQueryT Method (String, Object)

Creates a SQLiteCommand given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.

Namespace: Unvired.Kernel.SQLite
Assembly: Unvired.Kernel.UWP (in Unvired.Kernel.UWP.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C++

Copy

public IEnumerable<T> DeferredQuery<T>(
	string query,
	params Object[] args
)
where T : new()

Public Function DeferredQuery(Of T As New) ( 
	query As String,
	ParamArray args As Object()
) As IEnumerable(Of T)

public:
generic<typename T>
where T : gcnew()
IEnumerable<T>^ DeferredQuery(
	String^ query, 
	... array<Object^>^ args
)

member DeferredQuery : 
        query : string * 
        args : Object[] -> IEnumerable<'T>  when 'T : new()

Parameters

query: Type: SystemString
The fully escaped SQL.
args: Type: SystemObject
Arguments to substitute for the occurences of '?' in the query.

Type Parameters

T

Return Value

Type: IEnumerableT
An enumerable with one result for each row returned by the query. The enumerator will call sqlite3_step on each call to MoveNext, so the database connection must remain open for the lifetime of the enumerator.

Reference

SQLiteConnection Class

DeferredQuery Overload

Unvired.Kernel.SQLite Namespace