Click or drag to resize

SelfServicingExtensionMethodsFetchAsDataTable Method (IDao, DynamicQuery, DataTable, ITransaction)

Fetches the specified query into the DataTable specified and returns that datatable.

Namespace:  SD.LLBLGen.Pro.QuerySpec.SelfServicing
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.10.0.0 (5.10.0)
Syntax
Copy
public static DataTable FetchAsDataTable(
	this IDao dao,
	DynamicQuery query,
	DataTable destination,
	ITransaction transaction
)

Parameters

dao
Type: SD.LLBLGen.Pro.ORMSupportClassesIDao
The DAO instance.
query
Type: SD.LLBLGen.Pro.QuerySpecDynamicQuery
The query.
destination
Type: System.DataDataTable
The destination datatable to fetch the data into.
transaction
Type: SD.LLBLGen.Pro.ORMSupportClassesITransaction
The transaction.

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 IDao. 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