Cracking the Mysteries of Sybase SqlAnywhere with .NET
.NET developers can add the powerful capabilities of SQL Anywhere Anywhere Technology to their applications by using .NET programming interfaces and web services.
SQL Anywhere Studio makes the most of the services provided by .NET to let
developers add its capabilities to their applications using the Support
integration with .NET1.0, 1.1, 2.0 and ADO.NET 1.0, 2.0
Making data available through
.NET
SQL Anywhere implements ADO.NET that provides an interface to relational
data.
ADO.NET is the preferred data access component for the Microsoft .NET Framework
The In ado.net data provider is being used to facilitate the integration
of data with .NET applications
The sSupported Providers 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 iAnywhere.Data.UltraLite
namespace
Moving data to wherever
it is needed
SQL Anywhere also provides web services, used by Microsoft .NET and other
enterprise integration platforms as an XML-based mechanism for distributioned
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 a 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
to use 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 will should help developers to be more
productive, and it also should allows faster and more flexible modification
of enterprise applications for the .NET environment.
Conclusion
SQL Anywhere Studio provides a wide range of .NET support applications.
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.
MobiLink gives you full accessability to the functionsality of the .NET
Common Runtime Languages by allowing you to write your synchronization scripts
in any of the supported .NET languages, and QAnywhere brings messaging to
desktop and mobile devices with a .NET programming interface.
Author:
By Dhori Alpesh
Dhori Alpesh is working as a Programmer at Semaphore Infotech Pvt. Ltd, India. He has more than 1 year Experience in .net, oracle, sql, mysql. You can contact me on my email alpesh@semaphore-software.com.
About the Author
Rating: Not yet rated