The new "WCF LOB Adapter SDK"-based SQL Adapter - Features
The current release of the Adapter Pack contains the SAP, Siebel and Oracle adapters (written using the WCF LOB Adapter SDK).
For the next release of the Adapter Pack, one of the adapters which we're adding is a SQL Adapter. Some of the features which we're addressing are:
- SQL 2005 and SQL 2008 datatypes (XML, VARCHAR(MAX), VARBINARY(MAX), Date, Time, DateTime2, DateTimeOffset, Geometry, Geography, HierarchyId)
- User Defined Types (UDTs - these can be defined in .NET assemblies)
- Table Parameters in Functions and Stored Procedures
- 64 bit
- Enterprise SSO
- User-defined schemas (schemas other than dbo)
- Specifying the transaction IsolationLevel to use during polling
- An ExecuteReader() operation which can be used to execute arbitrary SQL statements at runtime
- Executing any stored procedure - FOR XML is no longer required.
- Supporting multiple resultsets in the response - either from stored procedure execution, or from arbitrary SQL statements, and for both - outbound as well as polling scenarios
- Ability to specify a post poll statement for polling scenarios
- Streamed operations for reading/writing from/to VARCHAR(MAX) and VARBINARY(MAX) columns
- Dynamic Ports (i.e., specifying the Connection URI within an orchestration)
Are there any other features which you would like to see in a new SQL Adapter? Please do let us know.
We're looking for TAP customers to try out and validate the features in the new adapter. An alpha release of the adapter (having all the above features) is also currently available, so if you're interested, please do let us know and join the TAP program.