The primary end-user object for accessing and manipulating data within the Hydrus Software DataSetToolkit utility.

For a list of all members of this type, see MultiTableDataAdapter Members.

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DataAdapter
            Hydrus.DataSetToolkit.MultiTableDataAdapter

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Remarks

The MultiTableDataAdapter provides the main entry point for selecting, inserting, updating, and deleting data with your DataSet. Rather than writing your own custom commands for each set of data, you simply specify certain tables or columns, along with constraints to one of the MultiTableDataAdapter's fill or update operations. You may also enlist MultiTableDataAdapter operations in your existing transactions by utilizing the appropriate overload method.

Example

A simple c# example of creating a MultiTableDataAdapter object, and loading a table.

using System;
using System.Data;
using Hydrus.DataSetToolkit;
public class GetData
{
    CommandBuilder hydrusBuilder;    
    MultiTableDataAdapter multiTableAdapter;
    MyCompanyNamespace.MyTypedDataSet myDataSet;
    const string invariantString = "System.Data.SqlClient";
    public GetData()
    {
        myDataSet = new MyCompanyNamespace.MyTypedDataSet();
        multiTableAdapter = new multiTableAdapter();
        hydrusBuilder = new CommandBuilder(


                    DatabaseProvider.SqlServer


                   ,multiTableAdapter


                   ,ConfigurationSettings.AppSettings["SqlConnectionString"]


                   ,60)
        multiTableAdapter.Fill(myDataSet.User);
    }
}

Requirements

Namespace: Hydrus.DataSetToolkit

Assembly: DataSetToolkit (in DataSetToolkit.dll)

See Also

MultiTableDataAdapter Members | Hydrus.DataSetToolkit Namespace | CommandBuilder | IWhereConstraint

---