AsyncAdapterExtensionMethods.FetchAsDataTableAsync Method (IDataAccessAdapter, DynamicQuery, DataTable)

AsyncAdapterExtensionMethodsFetchAsDataTableAsync Method (IDataAccessAdapter, DynamicQuery, DataTable)

Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery, DataTable). Fetches the specified query into the DataTable specified and returns that datatable.

Namespace: SD.LLBLGen.Pro.QuerySpec.Adapter
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.0.0.0 (5.0.0)

Syntax

Copy

public static Task<DataTable> FetchAsDataTableAsync(
	this IDataAccessAdapter adapter,
	DynamicQuery query,
	DataTable destination
)

<ExtensionAttribute>
Public Shared Function FetchAsDataTableAsync ( 
	adapter As IDataAccessAdapter,
	query As DynamicQuery,
	destination As DataTable
) As Task(Of DataTable)

Parameters

adapter: Type: SD.LLBLGen.Pro.ORMSupportClassesIDataAccessAdapter
The adapter.
query: Type: SD.LLBLGen.Pro.QuerySpecDynamicQuery
The query.
destination: Type: System.DataDataTable
The destination datatable to fetch the data into.

Return Value

Type: TaskDataTable
the destination datatable specified.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type IDataAccessAdapter. 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).

Remarks

If the DataTable specified already has columns defined, they have to have compatible types and have to be in the same order as the columns in the resultset of the query. It's recommended to have columns with the same names as the resultset of the query, to be able to convert null values to DBNull.Value.

Reference

AsyncAdapterExtensionMethods Class

FetchAsDataTableAsync Overload

SD.LLBLGen.Pro.QuerySpec.Adapter Namespace