Hide

YetaWF.DataProvider.PostgreSQL Package Documentation

Display
Print

YetaWF.DataProvider.PostgreSQL.SQLBase.Direct_QueryListAsync Method

Executes the provided SQL statement(s) and returns a collection of objects (one for each row retrieved) of type TYPE.

Class: YetaWF.DataProvider.PostgreSQL.SQLBase
Namespace: YetaWF.DataProvider.PostgreSQL
Assembly: YetaWF.DataProvider.PostgreSQL

Syntax

public Task<List<TYPE>> Direct_QueryListAsync<TYPE>( string sql );
public Task<List<TYPE>> Direct_QueryListAsync<TYPE>(
    string sql,
    params object[] args );

Parameters

sql

The SQL statement(s).

args

Optional arguments that are passed when executing the SQL statements.

Return Value

Returns a collection of objects (one for each row retrieved) of type TYPE.

Remarks

This is used by application data providers to build and execute complex queries that are not possible with the standard data providers. Use of this method limits the application data provider to SQL repositories.

See Also YetaWF.DataProvider.PostgreSQL.SQLBase ClassYetaWF.DataProvider.PostgreSQLYetaWF.Core