|
| Recent
Articles |
Customer-Lead, Trust-based Value Generation Services
This article explains how an enterprise can leverage increased value generation, thereby aiding competitive advantage, by adoption of the `Enterprise Value Generation Service Orientated Architecture...
Web Services, Contracts And Copyright
What's the Deal With Contracts, Copyright and Web Related Services? If you're the client, make sure you include the following steps when hiring a service provider to ensure you don't get involved in a mess like a copyright or legal battle, no matter how much you...
Should Google Offer Its Own Services As A Tip?
I have been watching the latest spat against Google for offering "tips" on services and products that they offer, when some web searches are input into Google. The interesting part about this is that I don't know...
What Is A Portal?
Among other things, a post today by my friend Scott Karp over at Publishing 2.0 has helped crystallized for me just how inadequate a lot of the terminology is that we're using for Web services and communities - and not just the obvious kind of cringe-inducing terms like...
SaaS: The Death Knell For Corporate IT?
The Enterprise Irregulars clubhouse is all abuzz these days about SaaS (Software as a Service, aka on-demand, utility, cloud, utility/cloud computing in a multitenant environment, whatever) and whether it will...
Use The SoapDocumentMethod Attribute To...
I've done a lot of web services during the last couple of years and I simply love Service Oriented Architecture using SOAP. The power of using services as a means to create large connected systems are enormous...
SOASTA Founder Talks SOA And Services
Ken Gardner is founder and Executive Chairman of SOASTA, a privately-held technology company focused on developing visual software tools for the testing, certification, and demonstration of SOA-based systems. The company's product line allows business...
|
|
03.01.07
Capabilities Of Sybase SqlAnywhere With .NET Integration
 By Dhori Alpesh
.NET developers can add the powerful capabilities of SQL Anywhere 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 (Support integration with .NET.0, 1.1, 2.0 and ADO.NET 1.0, 2.0).
Making data available through .NET
SQL Anywhere implements ADO.NET which provides an interface to relational data.
ADO.NET is the preferred data access component for the Microsoft .NET Framework. In ado.net data providers 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 iAnywhere.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.
MobiLink gives you full access to the functionality 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.
About the Author:
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
|
