Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

Database programming design question

Hello there,

i'm working on a programming framework for a pretty large database application. One of the issues i've encountered is the usage of database connections throughout the the application.

I want to keep down the number of connections and i want to keep up the performance as much as possible.

Would the following idea be suitable:

Create a connection class;
At the start of the program create an instance of the connection object;
As i  dynamically create userobjects (forms and what not) where needed, i give a reference to the connection object as a constructor parameter of such an object.
Use the connexion where needed in methods contained in my user objects.

Thanks for the advice!
0
secuteamers
Asked:
secuteamers
1 Solution
 
rkelley534Commented:
I have done a few large database projects and I am currently using the Microsoft Data Access Application block



http://www.gotdotnet.com/workspaces/workspace.aspx?id=c20d12b0-af52-402b-9b7c-aaeb21d1f431

What i have is I have a class that handles my connection utilizing the DAAB. Then anytime i want to perform a Database function I just call the appropriate function in my class and it goes and talks to the ADOHelper (DAAB) and performs the action and then quits. In my case it is very speedy and keeps my connections to the server low.

Hope this helps.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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