using multiple databases e.g. access, mysql

D

donnacha

Well-known member
Joined
Feb 27, 2003
Messages
187
Hi folks,
I have written a 3-tier VB application using MS Access, but would also like to be able to use other databases such as MYSQL or SQL Server without having to change my application.

Does anybody have an example of how this can be done without too much pain.

Thanks for any help
 
Create different data access layers (DALs) that conform to one interface.

C#: 
public interface IDataProvider {

    bool UserExists();

}

public class MySqlProvider : IDataProvider {

    public bool UserExists {

		

    }

}
 
Back
Top