fbpx
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: OleDb connection in XSharp Core app.

OleDb connection in XSharp Core app. 2 months 3 days ago #9404

  hsc's Avatar Topic Author hsc Offline Posts: 108
Hi all,

which option is better
create one (global) OleDb connection and use it while the program is running
or
create a new connection for each SQL statement?

Juraj

Please Log in or Create an account to join the conversation.

OleDb connection in XSharp Core app. 2 months 3 days ago #9405

  lumberjack's Avatar lumberjack Offline Posts: 513
Hi Juraj,

hsc wrote: which option is better
create one (global) OleDb connection and use it while the program is running
or
create a new connection for each SQL statement?

It is choice I believe, but my preference is one connection that is opened and closed as required. I will create a connection per database. I have various systems that need to connect to various databases for independent systems and create statistical reports based on joined data.

I have a SetupDictionary (singleton) that keeps all my "global" settings and it has a Collection<strDbName, oConnection> that I can call when needed.
______________________
Johan Nel
George, South Africa

Please Log in or Create an account to join the conversation.

OleDb connection in XSharp Core app. 2 months 2 days ago #9430

  MathiasHakansson's Avatar MathiasHakansson Offline Posts: 49
Hi Jurai,

Connections are pooled (reused) in .net which means that you don't have to treat them as a precious resource. I would create one connection per data access object (DAO) that the application uses. That means that the number of connections depends on how you have designed your data access. My suggestions is that you make your DAO-objects small so that they only handle one type of data (not necessarily one table) and that they only live while the window and the Business Classes (BC) that uses the data are alive. This design will not limit you in future development like going multi threaded or changing data access technology.

/Mathias

Please Log in or Create an account to join the conversation.

  • Page:
  • 1