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

  • Thread starter Thread starter davidw
  • Start date Start date
D

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
 
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.
 
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.
Click to expand...

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

Cor
 
Hi David,

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