Jeff, Thank you for responding. No I am not using transactions, I guess I had assumed that the attribute would wrap the call in a transaction behind the scenes. If I wrap it in a transaction and call a commit on that transaction would it not be too late to do the rollback or does it intercept the call to the commit method of the transaction?
Thanks, Josh On Mar 26, 9:11 pm, "Jeff Brown" <[email protected]> wrote: > Are you using transactions? [Rollback] works by setting an ambient > transaction within the execution context of the test thread. After the test > runs it rolls back the transaction. > > Jeff. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > > Behalf Of joshlrogers > Sent: Thursday, March 26, 2009 12:26 PM > To: MbUnit.User > Subject: MbUnit Re: Rollback not working > > In an effort to try and figure this out when I implemented NHibernate then > Rollback works. However when I revert to the previous method it still does > not work. > > Thanks, > Josh > > On Mar 26, 1:47 pm, joshlrogers <[email protected]> wrote: > > Actually, no. This is a local db installation so it isn't having to > > go across the network at all. > > > Josh > > > On Mar 26, 1:35 pm, "Philip Japikse" <[email protected]> wrote: > > > > Is the sql server the same machine that you are running the tests > > > from? If you are going across machines, the configuration to handle > > > transactions get's squirly (it's not an MbUnit thing, it's a > > > security thing) > > > > Phil > > > Philip Japikse, MCSD.Net, MCDBA, CSM Principal Consultant Pinnacle > > > Solutions, Inc [email protected] > > > twitter/skimedic > > > (513) 312-5664 > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[email protected]] On > > > > Behalf Of joshlrogers > > > Sent: Thursday, March 26, 2009 10:16 AM > > > To: MbUnit.User > > > Subject: MbUnit Re: Rollback not working > > > > Sorry for the lack of information. This is on SQL 2005. > > > > I have a visual studio generated dataset that I call the stored > > > procedure from... > > > > public int AddCWTRatingGroup(CWTRatingGroup ratingGroup) > > > { > > > int? errorNumber = null, id = null; > > > string errorMessage = string.Empty; > > > > _CWTRatingGroupsTableAdapter.AddCWTRatingGroup > > > ( ratingGroup.Name > > > > ,ratingGroup.UserAdded > > > ,ref id > > > ,ref > > > errorNumber > > > ,ref > > > errorMessage); > > > > if( errorNumber != null ) > > > throw new Exception( string.Format( "Error {0}: > > > {1}", errorNumber, errorMessage )); > > > > return (int)id; > > > > } > > > > Thanks, > > > Josh > > > > On Mar 26, 9:03 am, "Philip Japikse" <[email protected]> wrote: > > > > What is the data store (SQL, Oracle, etc)? Can you show your DAL > code? > > > > > Phil > > > > Philip Japikse, MCSD.Net, MCDBA, CSM Principal Consultant Pinnacle > > > > Solutions, Inc [email protected] > > > > twitter/skimedic > > > > (513) 312-5664 > > > > > -----Original Message----- > > > > From: [email protected] > > > > [mailto:[email protected]] On > > > > > Behalf Of joshlrogers > > > > Sent: Thursday, March 26, 2009 9:50 AM > > > > To: MbUnit.User > > > > Subject: MbUnit Rollback not working > > > > > It is very likely I may be missing something, but I am unable to > > > > get rollback to successfully work. Here is my test: > > > > > [Test] > > > > [Rollback] > > > > public void DoesAddRulesGroupReturnValidValue() > > > > { > > > > CWTRatingGroup ratingGroup = new CWTRatingGroup(); > > > > > ratingGroup.Name = "Test Insertion Group"; > > > > ratingGroup.UserAdded = 1; > > > > > object returnVal = _CWTRatingDAL.AddCWTRatingGroup > > > > (ratingGroup); > > > > > Assert.IsInstanceOfType(typeof(int), returnVal); > > > > Assert.GreaterThanOrEqualTo<int>((int)returnVal, > > > > 0); > > > > > } > > > > > I have tried the Roll back with and without the > > > > IncludeSetupAndTearDown and there is no change the transaction is > > > > not rolled back. Now I am not using anything like NHibernate, I > > > > am just using my own data access layer. I am new to TDD > > > > development and switched to MbUnit from NUnit due to the rollback > > > > feature, I am hoping I can get it working. Any help would be greatly > appreciated! > > > > > Thank you in advance, > > > > Josh Rogers --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "MbUnit.User" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MbUnitUser?hl=en -~----------~----~----~----~------~----~------~--~---
