?
Solved

Database programming design question

Posted on 2005-04-05
4
Medium Priority
?
151 Views
Last Modified: 2010-04-16
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
Comment
Question by:secuteamers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 2

Accepted Solution

by:
rkelley534 earned 1000 total points
ID: 13709801
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question