Typed Dataset and IDbDataAdapter

[Vaap]

I am trying to get dataset working through IDbDataAdapter interface as
my solution need to work with Sql Server and Oracle ODP. I am using
different data provider factories and the code here only shows SQL
Server.

My code snippets are

// Build the interface in provider factory (_pf in code below)
public IDbDataAdapter CreateDataAdapt er()
{
return (IDbDataAdapter ) new SqlDataAdapter( );
}
....
Instantiate the class using reflection depending upon data provider
factory selection through web.config

//
....
public IDbDataAdapter DataAdapter = null;

public void prepareDataSet( string SQL)
{
connect();
DataAdapter = _pf.CreateDataA dapter();
DataAdapter.Sel ectCommand = _pf.CreateComma nd(SQL,_connect ion);
}

I use this method from data access layer class to fill the dataset.

public DataSet GetContactAuth( DataSet ds)
{
string sql = "SELECT * FROM contact_auth";
db.prepareDataS et(sql);
db.DataAdapter. Fill(ds);
return ds;
}

I call this method from my business layer

public DatasetContactA uth execute(string userName, string password)
{
DatasetContactA uth dsLogin = null;
try
{
connectToDb();
ContactDAL dal = new ContactDAL(getD b());
dsLogin = (DatasetContact Auth) dal.GetContactA uth(new
DatasetContactA uth());
disconnectFromD b();
}
catch(Exception e)
{
ExceptionManage r.Publish(e);
this.ErrorMsg = "Error in getting Contact information. Please
contact your system administrator." ;
}
return dsLogin;
}

The Problem :

If I use typed dataset and use direct SQLClient API then I have to use
Fill(ds,"Table_ name") to fill the dataset. Fill(ds) alone does not
work.

The IDbDataAdapter interface has only one overloaded method of Fill as
against 7 or more available in DBDataAdapter in System.Data.Com mon.

I am at loss to figure this out. Is there something, you can point out
to help me.

My requirements:

1. I have to use typed datasets. Weak datasets are not an option.
2. I have to use Interfaces to make code work with different data
providers.

How do I fill my typed dataset under this condition using
IDbDataAdapter interface.

I am new to .net so please pardon my ignorance.

I appreciate your help.

-Regards.

[Miha Markic]

Hi,

The Problem :

If I use typed dataset and use direct SQLClient API then I have to use
Fill(ds,"Table_ name") to fill the dataset. Fill(ds) alone does not
work.
It works, but if probably fills another table (based on select from).
Either use that or pass DataTable directly to Fill.
The IDbDataAdapter interface has only one overloaded method of Fill as
against 7 or more available in DBDataAdapter in System.Data.Com mon.

I am at loss to figure this out. Is there something, you can point out
to help me.

My requirements:

1. I have to use typed datasets. Weak datasets are not an option.
2. I have to use Interfaces to make code work with different data
providers.

How do I fill my typed dataset under this condition using
IDbDataAdapter interface.

Every adapter is derived from DbDataAdapter.
So, you might just cast to DbDataAdapter or use DbDataAdapter instead of
IDbDataAdapter. ..

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

[Vaap]

"Miha Markic" <miha at rthand com> wrote in message

It works, but if probably fills another table (based on select from).
Either use that or pass DataTable directly to Fill.
You were right. The fill created a table name called "Table" and this
"table" got added in addition to one that was already there. - Thanks
Every adapter is derived from DbDataAdapter.
So, you might just cast to DbDataAdapter or use DbDataAdapter instead ofIDbDataAdapter ...

I used this and then used overloaded method of fill(ds,"CONTAC T_AUTH")
and it worked. - Thanks