Develop Applications
Learn how to develop and deploy applications with the Adaptive Server ADO.NET Data
Provider.
- Using Data Provider in a Visual Studio .NET Project
Review the changes you must make to your Visual Studio .NET project, after you install Adaptive Server ADO.NET Data Provider.
- Connecting to an Adaptive Server Database
Write code to connect to an Adaptive Server database. Before you can carry out any operations, your application must connect to the database.
- DDEX Provider for Adaptive Server
Data Designer Extensibility (DDEX) Provider for Adaptive Server enables Visual Studio components, such as Server Explorer, to interact with Adaptive Server and its objects through the Adaptive Server ADO.NET Data Provider.
- 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.
- Stored Procedures
You can use stored procedures with Adaptive Server ADO.NET Data Provider. The ExecuteReader method is used to call stored procedures that return a result set.
- Alternate Way to Call a Stored Procedure
You can also call a stored procedure using call syntax. This syntax is compatible with ODBC and JDBC.
- Transaction Processing
With Adaptive Server ADO.NET Data Provider, you can use the AseTransaction object to group statements together.
- Error Handling
Your application must be designed to handle any errors that occur, including ADO.NET errors.
- Performance Consideration
Review the tips on developing and deploying applications with the Adaptive Server ADO.NET Data Provider.
Created June 6, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com