TO ROBINSON, RE: Keeping connection _OPEN_ in ADO.net

  • Thread starter Thread starter punjab_tom
  • Start date Start date
P

punjab_tom

Robinson

I found something where you say I can keep a connection open in .net
and I've got books from MS press that say that I can't do this.

This is probably one of my top three pet peeves in .NET (right up
there with: a) framework not being on anyones desktop b) vbScript not
workign clientside in ASP.net)

Robinson; you said this:
and I really really need a clarification on this.

Can I open a connection; create a temp table; run another data reader;
come back to the same connection and my temp table is still there?

because I could do that in ADO and I did it all day long; thanks for
the clarification


You can do so very easily...

Dim myConnection as new SqlConnection (....)


.....


myConnection.Dispose ()
 
please if someone helps me to understand this; I would be glad to
recieve a corrected version of the MS press book.

In ADO; I can open a conneciton; and I can leave it open.
I am of the understanding that ADO.net cannot do this; and I found a
reference where Robinson was attempting to contradict me

if it's true-- that I can FRIGGIN keep a simple connection _OPEN_ then
maybe i'll have solved one of my top 3 complaints about DOTNET _CRAP_



THanks
 
yeah; it sure would be nice if we could keep a connection open

UNNECESSARY CHANGE IS _NOT_ SEXY
UNNECESSARY CHANGE IS _NOT_ NECESSARY
UNNECESSARY CHANGE IS _NOT_ WANTED
UNNECESSARY CHANGE IS _NOT_ ACCEPTABLE
 
robinson are you going to stand by your incorrection?

you cannot keep a connection open.. MS wanted to help us out and did
things like:

a) automagically closing connecitons
b) deciding that we don't need a movenext and let us use .READ instead
LoL

WHY?

BECAUSE OF THE LARGE AMOUNTS OF LIQUOR AND METH IN REDMOND!!!
BECAUSE OF THE LARGE AMOUNTS OF LIQUOR AND METH IN REDMOND!!!
BECAUSE OF THE LARGE AMOUNTS OF LIQUOR AND METH IN REDMOND!!!
BECAUSE OF THE LARGE AMOUNTS OF LIQUOR AND METH IN REDMOND!!!
 
Back
Top