Re: Is there ever a reason to have a transaction around a select..

Depends on default implicit transaction defined by database on what records you get.
Anyway, what exactly are "self-consistent" records?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message news:82C164CA-07CB-4520-9779-593F604D7338@xxxxxxxxxxxxxxxx
I guess my question is if there is no transaction, will the ResultSet come
back self-consistent? I know a split-second later it could be wrong as an
insert or update can hit the table but that is also true with a transaction
after I call Commit after the select.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm




"Miha Markic [MVP C#]" wrote:

It depends on your requirements but usually there is no need for (explicit)
transaction.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message
news:88DB2D9D-01F6-403F-93AF-1CABC892247B@xxxxxxxxxxxxxxxx
> 1) that will always return 0 or 1 rows?
>
> 2) that will retun N rows?
>
> In each case where the results will be displayed to the user and so > there
> can be changes that occur to the DB after the select completes.
>
> -- > thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
>



.

Relevant Pages

  • Re: Is there ever a reason to have a transaction around a select..
    ... This transaction stuff sure is complicated in the details. ... Cubicle Wars - http://www.windwardreports.com/film.htm ... what exactly are "self-consistent" records? ... Blog: http://cs.rthand.com/blogs/blog_with_righthand/ ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Objects new in Collection
    ... Ignacio Machin (.NET/ C# MVP) wrote: ... myOrder is not in that snapshot. ... the basic rules of transactions is: "Do not allow user interaction when ... the transaction runs". ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Does anyone have templates for M&A or financial tombstone annouc.p.s.
    ... Mary Sauer MS MVP ... "Tyndale" wrote in message ... > transaction and dollar amount of transaction, ...
    (microsoft.public.publisher)
  • Re: Windows service concept?
    ... William Stacey [C# MVP] ... Any reference paper or samples? ... |> transaction is complete or do a rollback. ...
    (microsoft.public.dotnet.framework)
  • Re: Global Transacted Connection Question
    ... - Sahil Malik [MVP] ... This is because then you have a resource ... >> due to the transaction for an indefinite time. ...
    (microsoft.public.dotnet.framework.adonet)
Loading