[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 643
  • Last Modified:

Database Compatibility

How to make asp.net web site compatibility with SQL SERVER, MY SQL and PROSTGRE SQL
i want to use ALL the database and application will ask me which database you want to select then based on selected databse my application will work how to overcome this problem
1 Solution
You need to create a class for the connection to the database.

When users decide the database to use you create the connection to database with the type selected, depending on that type you use one connection string or another.

On your app, when accessing database you always use the connection class, which will be pointing to the database type selected.
Keep ALL SQL code out of your application - use ONLY stored procedure calls.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now