Microsoft Visual Studio DataSet designer generates code (C#/VB.NET) to read data from a .NET Data Provider data source or apply changes to the data source. DataSet designer generates parameterized queries and sets the properties of DbParameter object to the corresponding column data type attributes. For example it sets DbParameter.DbType to DbType.String or DbType.Decimal. It also sets the DbParameter.Size to the column size which is the maximum number of characters for Char/VarChar columns.

This blog discusses how Query Bands have been implemented in the .Net Data Provider for Teradata 13.01.00.00.

I have placed the Guidelines first because I know many of you are already familiar with Query Bands, and are primarily interested in the guidelines on using Query Bands with the .Net Data Provider for Teradata. If you would like further details refer to the other sections.

Here is a summary of each of the sections:

Guidelines/Tips

Microsoft and Teradata worked together last year to integrate SQL Server Reporting, Analysis and Integration Services with Teradata Database. Some MSDN links that provide additional information:

.NET Framework has a very broad support for Asynchronous operations including a well defined Asynchronous Programming Model. All asynchronous operations are started by invoking a Begin method; later a corresponding End method is invoked to retrieve the result. .NET Application can use three different techniques to rendezvous with the asynchronous operation: a) Callback Method b) Poll for status and c) Wait on a thread synchronization handle.