How to use OpenLink.Data.GenericClient in DAAB

Topics: Data Access Application Block
Jan 18, 2010 at 10: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");

con.Open();

 

query = "SELECT * FROM TABLE"

OPLCommand cmd = new OPLCommand(query, con);

OPLDataAdapter da = new OPLDataAdapter(cmd);

 

da.Fill(ds);

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 7:18 AM

You will need to create your DAAB provider for your OpenLink data provider.  Check out a sample for the ODP.Net provider - http://www.codeplex.com/entlibcontrib/WorkItem/View.aspx?WorkItemId=3167

 

Sarah Urmeneta
Global Technology & Solutions
Avanade, Inc.

entlib.support@avanade.com