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 -~----------~----~----~----~------~----~------~--~---
