Why do you need an open and close statement when making an SQL statement except when using an SQL adaptor?

Question

0.00/5 (No votes)

See more:

I was curious, I was trying to redo some of my code and found out by accident that if you choose to use an SQL adaptor you don't need an open and close statement, but why? whats the difference? Also which is better to use?

What I have tried:

No problems, just curious because I can change some of my code based upon the answers.

Posted 27-Jul-17 6:57am

Member 11856456

Updated 27-Jul-17 9:24am

Add a Solution

2 solutions

Solution 2

You might find reference source interesting. The filling is done in class DbDataAdapter in method called FillInternal.

If you investigate the code you'll see that the connection is opened and closed unless it's already open. If the connection is initially in open state, it's left that way.

Have a look at Reference Source - DbDataAdapter[^]

Posted 27-Jul-17 9:24am

Wendelius

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2017-07-27T07:16:00

Solution 1

Because, internally, the DbDataAdapter classes open and close the connection themselves.

Posted 27-Jul-17 7:16am

Dave Kreskowiak

Comments

Member 11856456 27-Jul-17 13:22pm

So it would be best to use an adaptor over a regular statement? i didn't know that the connections would open and close by themselves. What about previous data accessed, is it disposed of before the new data is accessed?

Dave Kreskowiak 27-Jul-17 13:51pm

It does not Dispose anything for you. You still have to do that yourself.

A DataAdapter is good for maintaining a DataTable object if you need to use that, but it has penalties for using it due to its "generic for all situations" nature and implementation.

If you're handing managing all the data and updates yourself (I always do), then you don't need a DataAdapter.

If you're handling large sets of data where the data is too large to fit in memory all at once, you cannot use a DataSet, DataTable, and DataAdapter.