Hi
I have a database application written in C# for a theological college. If I want to use the same application for another college at a different site with another database, what is the best way to connect to the database.
I currently use a connection string but that means changing the string for each college.
Is there a way to have a generic connection method? Is the best to use odbc to connect to the database or is there a better method.
I am trying to make the application portable without having to make changes for each college.
Just point me in the right direction, I don't believe in being given the code, it is not the way to learn.
Thank you, much appreciated.
I have a database application written in C# for a theological college. If I want to use the same application for another college at a different site with another database, what is the best way to connect to the database.
I currently use a connection string but that means changing the string for each college.
Is there a way to have a generic connection method? Is the best to use odbc to connect to the database or is there a better method.
I am trying to make the application portable without having to make changes for each college.
Just point me in the right direction, I don't believe in being given the code, it is not the way to learn.
Thank you, much appreciated.