SAP Sybase IQ .NET Data Provider

This section describes .NET support, including tips on using the SAP Sybase IQ .NET Data Provider in Visual Studio projects, connecting to databases, fetching, inserting, updating and deleting rows from database tables, calling stored procedures, using transactions, and basic error handling.

• SAP Sybase IQ .NET Support
  ADO.NET is the latest data access API from Microsoft in the line of ODBC, OLE DB, and ADO. It is the preferred data access component for the Microsoft .NET Framework and allows you to access relational database systems.
• SAP Sybase IQ .NET Data Provider Features
  SAP Sybase IQ supports the Microsoft .NET Framework versions 2.0, 3.0, 3.5, 4.0, and 4.5 through three distinct namespaces.
• .NET Sample Projects
  There are several sample projects included with the SAP Sybase IQ .NET Data Provider:
• Using the .NET Data Provider in a Visual Studio Project
  Use the SAP Sybase IQ .NET Data Provider to develop .NET applications with Visual Studio by including both a reference to the SAP Sybase IQ .NET Data Provider, and a line in your source code referencing the SAP Sybase IQ .NET Data Provider classes.
• .NET Database Connection Examples
  To connect to a database, an SAConnection object must be created. The connection string can be specified when creating the object or it can be established later by setting the ConnectionString property.
• Data Access and Manipulation
  With the SAP Sybase IQ .NET Data Provider, there are two ways you can access data:
• Stored Procedures
  You can use SQL stored procedures with the SAP Sybase IQ .NET Data Provider.
• Transaction Processing
  With the SAP Sybase IQ .NET Data Provider, you can use the SATransaction object to group statements together. Each transaction ends with a COMMIT or ROLLBACK, which either makes your changes to the database permanent or cancels all the operations in the transaction. Once the transaction is complete, you must create a new SATransaction object to make further changes. This behavior is different from ODBC and embedded SQL, where a transaction persists after you execute a COMMIT or ROLLBACK until the transaction is closed.
• Error handling
  Your application should be designed to handle any errors that occur.
• Entity Framework Support
  The SAP Sybase IQ .NET Data Provider supports Entity Framework 4.3, a separate package available from Microsoft. To use Entity Framework 4.3,you must add it to Visual Studio using Microsoft's NuGet Package Manager.
• SAP Sybase IQ .NET Data Provider Deployment
  The following sections describe how to deploy the SAP Sybase IQ .NET Data Provider.
• .NET Tracing Support
  The SAP Sybase IQ .NET Data Provider supports tracing using the .NET tracing feature.