Click or drag to resize

AdapterExtensionMethodsFetchAsDataTable Method (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.11.0.0 (5.11.23.1114)
Syntax
Copy
public static DataTable FetchAsDataTable(
	this IDataAccessAdapter adapter,
	DynamicQuery query,
	DataTable destination
)

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: DataTable
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.
See Also