Data Acess DLL

[breydan]

Hi all:

I'll like to know a source about how to create a dll for Data Acess purposes. I want to create (if possible) a dll an call a function from that dll to make a search on a database. I'm using VC 6.0 and foxpro tables.

Thank you,

Daniel Hernandez

 

[Cagliostro]

Why do you need that? There already exist a lot of data access dll's. For example look in ODBC at the list of database drivers.

Ion Filipski

 

[obislavu]

Ion is right but for an open architecture application you need such libraries.
As I understand you need something that .NET DataAdapter classes offer e.g. a set of data commands and a database connection that are used to work with databases.
There are SqlDataAdapter for the SQL databases and OleDbDataAdapter for other databases such Oracle, MSACCESS, DB2 ..
One would like to encapsulate the SQL* and Ole* in one dll or many dlld in order to have a something named Data Access Layer. A client of these dlls, just will choose the DataAdapter to create and will pass execute commands to the DataAdapter object to be performed on the database.
I explained that here because .NET offers the patterns to do this kind of work.
-obislavu