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.3.0)
public static DataTable FetchAsDataTable(
	this IDataAccessAdapter adapter,
	DynamicQuery query,
	DataTable destination


Type: SD.LLBLGen.Pro.ORMSupportClassesIDataAccessAdapter
The adapter.
Type: SD.LLBLGen.Pro.QuerySpecDynamicQuery
The query.
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).
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