RelationalStorageExtensions.ReadAsync Método

Definição

Namespace:

Orleans.SqlUtils

Assembly:

OrleansSQLUtils.dll

Pacote:

Microsoft.Orleans.OrleansSqlUtils v1.5.10

Sobrecargas

ReadAsync<TResult>(IRelationalStorage, String, CancellationToken)	IRelationalStorage Usa com DbExtensions.ReflectionParameterProvider.
ReadAsync<TResult>(IRelationalStorage, String, Func<IDataRecord,TResult>, Action<IDbCommand>)	Uma versão simplificada do ReadAsync<TResult>(String, Action<IDbCommand>, Func<IDataRecord,Int32,CancellationToken,Task<TResult>>, CancellationToken, CommandBehavior)
ReadAsync<TResult>(IRelationalStorage, String, Object, CancellationToken)	IRelationalStorage Usa com ReflectionParameterProvider<T>(IDbCommand, T, IReadOnlyDictionary<String,String>).

ReadAsync<TResult>(IRelationalStorage, String, CancellationToken)

IRelationalStorage Usa com DbExtensions.ReflectionParameterProvider.

public static System.Threading.Tasks.Task<System.Collections.Generic.IEnumerable<TResult>> ReadAsync<TResult>(this Orleans.SqlUtils.IRelationalStorage storage, string query, System.Threading.CancellationToken cancellationToken = default);

static member ReadAsync : Orleans.SqlUtils.IRelationalStorage * string * System.Threading.CancellationToken -> System.Threading.Tasks.Task<seq<'Result>>

<Extension()>
Public Function ReadAsync(Of TResult) (storage As IRelationalStorage, query As String, Optional cancellationToken As CancellationToken = Nothing) As Task(Of IEnumerable(Of TResult))

Parâmetros de tipo

TResult

O tipo do resultado.

Parâmetros

storage

IRelationalStorage

O armazenamento a ser usado.

query

String

Executa uma determinada instrução. Especialmente destinado a usar com a instrução SELECT , mas também funciona com outras consultas.

cancellationToken

CancellationToken

O token de cancelamento. Assume o padrão de None.

Retornos

Task<IEnumerable<TResult>>

Uma lista de objetos como resultado do .

ReadAsync<TResult>(IRelationalStorage, String, Func<IDataRecord,TResult>, Action<IDbCommand>)

Uma versão simplificada do ReadAsync<TResult>(String, Action<IDbCommand>, Func<IDataRecord,Int32,CancellationToken,Task<TResult>>, CancellationToken, CommandBehavior)

public static System.Threading.Tasks.Task<System.Collections.Generic.IEnumerable<TResult>> ReadAsync<TResult>(this Orleans.SqlUtils.IRelationalStorage storage, string query, Func<System.Data.IDataRecord,TResult> selector, Action<System.Data.IDbCommand> parameterProvider);

static member ReadAsync : Orleans.SqlUtils.IRelationalStorage * string * Func<System.Data.IDataRecord, 'Result> * Action<System.Data.IDbCommand> -> System.Threading.Tasks.Task<seq<'Result>>

<Extension()>
Public Function ReadAsync(Of TResult) (storage As IRelationalStorage, query As String, selector As Func(Of IDataRecord, TResult), parameterProvider As Action(Of IDbCommand)) As Task(Of IEnumerable(Of TResult))

Parâmetros de tipo

TResult

Parâmetros

storage

IRelationalStorage

query

String

selector

Func<IDataRecord,TResult>

parameterProvider

Action<IDbCommand>

Retornos

Task<IEnumerable<TResult>>

ReadAsync<TResult>(IRelationalStorage, String, Object, CancellationToken)

IRelationalStorage Usa com ReflectionParameterProvider<T>(IDbCommand, T, IReadOnlyDictionary<String,String>).

public static System.Threading.Tasks.Task<System.Collections.Generic.IEnumerable<TResult>> ReadAsync<TResult>(this Orleans.SqlUtils.IRelationalStorage storage, string query, object parameters, System.Threading.CancellationToken cancellationToken = default);

static member ReadAsync : Orleans.SqlUtils.IRelationalStorage * string * obj * System.Threading.CancellationToken -> System.Threading.Tasks.Task<seq<'Result>>

<Extension()>
Public Function ReadAsync(Of TResult) (storage As IRelationalStorage, query As String, parameters As Object, Optional cancellationToken As CancellationToken = Nothing) As Task(Of IEnumerable(Of TResult))

Parâmetros de tipo

TResult

O tipo do resultado.

Parâmetros

storage

IRelationalStorage

O armazenamento a ser usado.

query

String

Executa uma determinada instrução. Especialmente destinado a usar com a instrução SELECT , mas também funciona com outras consultas.

parameters

Object

Adiciona parâmetros à consulta. Os nomes de parâmetro devem corresponder aos definidos na consulta.

cancellationToken

CancellationToken

O token de cancelamento. Assume o padrão de None.

Retornos

Task<IEnumerable<TResult>>

Uma lista de objetos como resultado do .

Exemplos

Isso usa reflexão para ler resultados e corresponder aos parâmetros.

//This struct holds the return value in this example.        
public struct Information
{
    public string TABLE_CATALOG { get; set; }
    public string TABLE_NAME { get; set; }
}

//Here reflection (<seealso cref="M:Orleans.SqlUtils.DbExtensions.ReflectionParameterProvider``1(System.Data.IDbCommand,``0,System.Collections.Generic.IReadOnlyDictionary{System.String,System.String})"></seealso>)
is used to match parameter names as well as to read back the results (<seealso cref="M:Orleans.SqlUtils.DbExtensions.ReflectionSelector``1(System.Data.IDataRecord)"></seealso>).
var query = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @tname;";
IEnumerable<Information> informationData = await db.ReadAsync<Information>(query, new { tname = 200000 });