"Mike" <Mike@discussions.microsoft.com> wrote in message
news:07156B16-A98D-4D89-8238-F34313D8C7AD@microsoft.com...
> The DBCommandWrapper class doesn't exist in Enterprise Library because
it's
> properties/methods have been relocated to other classes. Where did the
> RowsAffected properties go? I can't find this property anywhere?
>
> I use this property when, for example, calling SQL 'Update' stored
> procedures. I call the procedure, and then evaluate the number of
affected
> records to determine if the command completed successfully.
>
> Thanks.

"sloan" wrote:

>
> First, Selects are not in this number.
>
> Second, make sure NOCOUNT OFF
> is set.
>
> Aka, when you set NOCOUNT ON, you're saying "don't report a rowcount", thus
> ExecuteNonQuery does not work.
>
>
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:465C0E93-DCAB-414F-8EEA-0E20EA26377B@microsoft.com...
> > sloan, I consistantly get -1 as the int value using that method. I
> execute
> > UPDATE and DELETE stored procs, and despite that they successfully UPDATE
> or
> > DELETE one row, it returns -1. Shouldn't it return 1?
> >
> > Thanks for your help.
> >
> > "sloan" wrote:
> >
> > > Its just the return value of ExecuteNonQuery
> > >
> > > aka
> > >
> > > int ExecuteNonQuery
> > >
> > > int myvalue = db.ExecuteNonQuery( dbc , ....................... ) ;
> > >
> > >
> > >
> > > "Mike" <Mike@discussions.microsoft.com> wrote in message
> > > news:07156B16-A98D-4D89-8238-F34313D8C7AD@microsoft.com...
> > > > The DBCommandWrapper class doesn't exist in Enterprise Library because
> > > it's
> > > > properties/methods have been relocated to other classes. Where did
> the
> > > > RowsAffected properties go? I can't find this property anywhere?
> > > >
> > > > I use this property when, for example, calling SQL 'Update' stored
> > > > procedures. I call the procedure, and then evaluate the number of
> > > affected
> > > > records to determine if the command completed successfully.
> > > >
> > > > Thanks.
> > >
> > >
> > >
>
>