Changing Database from Access to Sql Server in .Net Application

.NET
1

Hi,

I have a website which need to be upgraded from access to sql server and thus I have to go to each file one by one and change each database connection object (example: Oledbdatareader to SqlDataReader).

I need to know if there is any way we could use when developing a .net application where we define database objects in one single file and it can be used globally. This way changing from one database to another would become very easier.

Any idea, any help

2

Fundamentally your problem is you are talking to the database directly in every file – you should really have a service layer that handles that rather than directly reference ADO.NET.

You also might want to look at modern conveniences like ORMs while you are at it.