How to use OpenLink.Data.GenericClient in DAAB

Topics: Data Access Application Block
Jan 18, 2010 at 9:01 AM

I am using OpenLink.Data.GenericClient.dll to connect to QAD Database and get records. Below code explains how I am fetching data using this OpenLink.

DataSet ds = new DataSet();

string query;

OPLConnection con = new OPLConnection("connectionstring");




OPLCommand cmd = new OPLCommand(query, con);

OPLDataAdapter da = new OPLDataAdapter(cmd);



Instead of doing it in above way, I want to use DAAB to fill the DataSet. When I tried to create a ConnectionString in DAAB, it asking for a ProviderName.

In the ProviderName list, I can see only providers like System.Data.Odbc, System.Data.Oledb etc.....




Jan 19, 2010 at 6:18 AM

You will need to create your DAAB provider for your OpenLink data provider.  Check out a sample for the ODP.Net provider -


Sarah Urmeneta
Global Technology & Solutions
Avanade, Inc.