Hi All;
I am developing a generic ASP.NET 2 template site that we can use for as a base for our future applications. We previously used classic ASP.
My query is, is it possible for me to create a single database definition is a central location that all my controls and database classes can use to connect to a database. The reason for this is that we constantly switch between MSACCESS and MSSQL as a db based on demands.
In classic ASP this was easily done as we built a central connection string in an asp file that we could simply include on our pages. Therefore, if we made a change to this include page we could switch processing easily between an MSACCESS and MSSQL db.
Is a similiar approach possible with ASP.NET 2? I have been using GridView and OleDbReader to connect to a MSACCESS db. I noticed that C# has specific classes for MSSQL. Do I have to use this classes, or is there a generic database class which I can use to select/insert/update either an MSACCESS or MSSQL db?
Any and all recommendations/advice/help would be GREATLY appreciated!
Sean.
I am developing a generic ASP.NET 2 template site that we can use for as a base for our future applications. We previously used classic ASP.
My query is, is it possible for me to create a single database definition is a central location that all my controls and database classes can use to connect to a database. The reason for this is that we constantly switch between MSACCESS and MSSQL as a db based on demands.
In classic ASP this was easily done as we built a central connection string in an asp file that we could simply include on our pages. Therefore, if we made a change to this include page we could switch processing easily between an MSACCESS and MSSQL db.
Is a similiar approach possible with ASP.NET 2? I have been using GridView and OleDbReader to connect to a MSACCESS db. I noticed that C# has specific classes for MSSQL. Do I have to use this classes, or is there a generic database class which I can use to select/insert/update either an MSACCESS or MSSQL db?
Any and all recommendations/advice/help would be GREATLY appreciated!
Sean.