Ways to Access and Manipulate Data

With Adaptive Server ADO.NET Data Provider, there are two ways you can access data: using the AseCommand object, or using the AseDataAdapter object.

AseCommandObject object: The AseCommand object is the recommended way of accessing and manipulating data in .NET because the programmer has more control of connections. However, AseDataAdapter allows you to work offline.

The AseCommand object allows you to execute SQL statements that retrieve or modify data directly from the database. Using the AseCommand object, you can issue SQL statements and call stored procedures directly against the database.

Within an AseCommand object, you can use the AseDataReader class to return read-only result sets from a query or stored procedure.
AseDataAdapter object: The AseDataAdapter object retrieves the entire result set into a DataSet. A DataSet is a disconnected storage area for data that is retrieved from a database. You can then edit the data in the DataSet, and when you are finished, the AseDataAdapter object updates the database with the changes made to the DataSet. When you use the AseDataAdapter, there is no way to prevent other users from modifying the rows in your DataSet; you need to include logic within your application to resolve any conflicts that may occur.

Use AseCommand to Retrieve and Manipulate Data
Review information to insert, update, or delete rows and retrieve data using the AseDataReader.
Use AseDataAdapter to Access and Manipulate Data
You can retrieve data, insert, update, or delete rows using the AseDataAdapter.
Obtaining Primary Key Values
Use a stored procedure to obtain values generated by the data source if the table you are updating has an auto-incremented primary key, or if the primary key comes from a primary key pool.
BLOBs Handling
When fetching long string values or binary data, there are methods that you can use to fetch the data in pieces.
Obtaining Time Values
Use the GetDateTime() method if you want to fetch time values from Adaptive Server since the .NET Framework does not have a Time structure. Using this method returns the data as a .NET Framework DateTime object.
Converting a Time Value Using the GetDateTime Method
Use the GetDateTime method to convert a time value.

Parent topic: Develop Applications

Related concepts

AseCommand Class

AseDataReader Class

Conflicts When Using the AseDataAdapter

AseDataAdapter Class