Compartir a través de

Sample SQL Adapter built using WCF LOB Adapter SDK

  • Artículo

WCF LOB Adapter SDK 'RC' ships with two sample adapters  -

  1. Contoso Adapter - uses a canned back-end defined using SQL Server 2005.
  2. Echo Adapter - a simple adapter that shows how to use WCF LOB Adapter SDK API and includes a usage pattern for inbound scenarios

Both of these adapters are limiting and don't truly capture building adapter for a real world line-of-business system. 

The team has recently finished creating a 'lite' SQL Server Adapter, that browses, searches and executes stored procedures in SQL Server 2005 database.  Each line-of-business system is unique and an adapter writer needs to have knowledge of the back-end system to create the adapter.  If you are a SQL Server guru and would expect some other functionality in a WCF-based adapter, feel free to extend this adapter. 

Click here to download this sample.  You can try this adapter out with AdventureWorks Sample Database.  

Following table shows the matrix of ASDK features used by this sample adapter.

·

·

·

·

·

·

·

·

·

·

·

 

 

SQLSampleAdapter.zip

Comments

  • Anonymous
    July 13, 2007
    Hi, thankz for the sample. Just wanted to know if going forward we can expect a fully implemented (and perhaps supported) SQL Server or even better ADO.NET based adapter from your team or we are on our own on that? And, just as a side note, reconsider the "WCF LOB Adapter SDK" moniker - it sounds very boringly microsoft'ish. Keep up the good work.

  • Anonymous
    July 17, 2007
    Are you using adapter data reader / writer derived classes? WCF LOB Adapter SDK team had introduced adapter

  • Anonymous
    August 13, 2007
    This sample SQL Sample Adapter does not work with the RTM version of teh SDK. Will you provide an updated sample which wokrs with RTM version of SDK? I really would like to know as I am wokring on a POC for my client and SQL Adapter sample will make the development time really short and make the over solution very clean. Any feedback will be appreciated.

  • Anonymous
    July 22, 2009
    The sample provided is not compiling. Do you have an updated solution for the sample attached?