Really want a answer, is there a mature way to access different data providers without performance l

[davidw]

I always used sqlclient to access my sql server, recently, I want to
develope some codes that can access data from other data providers, like
mysql, oracle. I found there are way to create universal data wrapper by
using adonet I?? interface, but I am still not sure if accessing sql server
with such way would comprise the performance a lot(compare to sqlclient).
Does anyone could point to me a way to develope general data layer?


thanks

 

[Cor]

Hi David,

You can use OleDB and ODBC also.

In this newsgroup William Vaughn is more for ODBC, while others are for
OleDB.

The performance from OleDB and ODBC is less than the performance form an
direct adapter as SqlClient.

Have a look at this

http://msdn.microsoft.com/library/d...y/en-us/cpguide/html/cpconadonetproviders.asp

I hope this helps?

Cor

 

[davidw]

Thanks for reply.

I did read the article you linked below recently, and a lot of other
articles. But I still have no clear idea what is the suggestion way to
develope a multi-datasource .NET program. Make it simple, if I want to make
I dll can support both SQL server and mysql, what is the ideal way? OLEDB
is much slower than sqlclient when connects to sql server, isn't it? ODBC
uses another layer so it is more inefficient? what about interface
IDBConnection,IDBCommand? I am not quite sure how they work, that is why I
ask question here.

 

[Cor]

Hi David,

I did read the article you linked below recently, and a lot of other
articles. But I still have no clear idea what is the suggestion way to
develope a multi-datasource .NET program. Make it simple, if I want to make
I dll can support both SQL server and mysql, what is the ideal way? OLEDB
is much slower than sqlclient when connects to sql server, isn't it? ODBC
uses another layer so it is more inefficient? what about interface
IDBConnection,IDBCommand? I am not quite sure how they work, that is why I
ask question here.

Ideal in my opinion 2 (or if Oracle in it 3) DLL's

Cor

 

[Miha Markic [MVP C#]]

Hi David,

One way is to create a factory pattern.
Depending on target datatabase you create appropriate instances and access
them through common interfaces.