ADO.NET is the preferred data access component for the Microsoft .NET Framework



In ado.net data provider used to facilitate the integration of data with .NET applications

Supported Provider are

The Adaptive Server Anywhere ADO.NET Provider

This provider is a native interface to the database, meaning that there is no intermediate bridging technology.which implements the iAnywhere.Data.AsaClient namespace

The UltraLite ADO.NET Provider

It makes the ADO.NET programming model available for UltraLite database access The UltraLite ADO.NET Data Provider implements the Anywhere.Data.UltraLite namespace

Moving data to where it is needed

SQL Anywhere also provides web services, used by Microsoft .NET and other enterprise integration platforms as an XML-based mechanism for distributed access to information over Internet protocols.

It provides both the ability to build web services in the database and the ability to access external web services from the database.

SQL Anywhere databases can act as web service clients, meaning that they can collect and integrate information from many locations.

The ability of Adaptive Server Anywhere to return the result sets of SELECT statements and stored procedures as XML provides a foundation for web services.

You can expose stored procedures or queries in your database as web services.

SQL Anywhere provides MobiLink data synchronization for "always available" data access in occasionally connected environments. Synchronization logic can be implemented using .NET programming languages.

SQL Anywhere includes QAnywhere messaging software that provides a .NET interface to application-to-application messaging for mobile computing.

Development tool

As part of an effort to provide more comprehensive support and integration with .NET, Sybase has released a new development tool that works in any .NET environment.

Sybase DataWindow .NET2.0 is being offered to allow developers the use of a single tool to incorporate data access, complex logic, and data presentation into .NET applications.

DataWindow creates point-and-click environments for easy data retrieval.

.NET's holistic approach should help developers be more productive, and should allow faster and more flexible modification of enterprise applications for the .NET environment.

Conclusion

SQL Anywhere Studio provides a wide range of .NET support.

The ADO.NET interface is fully supported in both Adaptive Server Anywhere and UltraLite databases. Adaptive Server Anywhere can act both as a provider of web services and can access external web services and make them available to client applications. You can import, export, and store XML in your Adaptive Server Anywhere database and make existing data available in XML form.