A new (WCF LOB Adapter SDK based) SQL Adapter

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 and DateTimeOffset)
• UDTs (which includes SQL 2008 UDTs like Geometry, Geography and HierarchyId)
• Table Parameters
• 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 to be returned - 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

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.