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.

With the DDEX Provider for Adaptive Server, you can:

Connect and log in to Adaptive Server from Visual Studio.
List Adaptive Server objects as hierarchy nodes in Visual Studio Server Explorer.
Drag and drop Adaptive Server tables and views from Server Explorer onto data designers.

The DDEX Provider for Adaptive Server is compatible with Visual Studio 2005, 2008, and 2010.

Connecting to Adaptive Server
Add a database connection to Adaptive Server using the Visual Studio Server Explorer view.
Viewing Adaptive Server Objects
View Adaptive Server objects and their related information in Visual Studio Server Explorer.
Supported Adaptive Server Objects
DDEX Provider for Adaptive Server exposes Adaptive Server objects, which can be viewed and accessed in the Visual Studio Server Explorer.
Enhanced DDEX Provider for Adaptive Server
You can use Entity Framework to create data models with Adaptive Server databases. This enhancement is supported in Visual Studio 2008 SP1 and Visual Studio 2010.
Adaptive Server ADO.NET Data Provider Support for SSIS
Adaptive Server ADO.NET Data Provider can be integrated into SQL Server Integration Services (SSIS), allowing for native access to ADO.NET Data Provider functions.

Parent topic: Develop Applications