Simplified Database Unit testing using Enterprise Services

re: Simplified Database Unit testing using Enterprise Services

Oscar Land — Thu, 08 Mar 2007 07:24:28 GMT

Dear Roy,

Could you pleased upload the source code sample of this article?

I couldn't make test with this. The error :

TestFixture failed: Invalid ServicedComponent-derived classes were found in the assembly.

Thanks. Best regards.

re: Simplified Database Unit testing using Enterprise Services

Fariba Ahvaz — Mon, 15 Jan 2007 13:02:37 GMT

Hi,

I have a problem in using com+ for transaction.

I used to use vb.net 2003. My program's architecture is 5 layers.

The Business objects and dataobjects are com+ objects.I use tcp channel for remoting and the atributes for com+ that I use are :

<Assembly: ApplicationName("App Name")>

<Assembly: ApplicationAccessControl(True)>

<Assembly: ApplicationActivation(ActivationOption.Server)>

<ComponentAccessControl(True), _

SecurityRole("MyRole", True), _

Transaction(TransactionOption.Required)>

and for all of my functions I use try/catch .at the end of try I use ContextUtil.SetComplete and In catch I use Contextutil.SetAbort. also I Inherit a class from Exception for my own exception.

but In one function I call 3 other functions.when the error of remoting has raised or when I throw my own exception, SetAbort does not work.

I will be glad If someone help.

Thanks

DataFresh - Database rollback library for unit tests

ISerializable - Roy Osherove's Blog — Fri, 13 Oct 2006 23:43:20 GMT

A while ago I wrote an article about database unit testing, and the various ways you could "rollback"

re: Simplified Database Unit testing using Enterprise Services

Mike Brockey — Fri, 13 Oct 2006 19:12:37 GMT

I have yet another solution to this very common problem. We have been able to isolate the steps for preparing a database snapshot, tracking the database modifications and then refreshing the modified tables back to their original state all using built in sql statements. We call it dataFresh and it is available now from our website as part of our TDD Developer's Toolkit, all free of charge. http://blogs.ent0.com/blogs/datafresh/default.aspx

re: Simplified Database Unit testing using Enterprise Services

Joe — Wed, 27 Sep 2006 18:32:16 GMT

I like your solution. I have a knowlege hole though, when you said "you ARE using a test database...". I don't see how, in the .net environment, to get all the connections that exist in all the forms changed back & forth from the test to the production database. Is there a book or website that describes this architecture and process? Thanks

re: Simplified Database Unit testing using Enterprise Services

Ian Blackburn — Mon, 31 Jul 2006 15:40:52 GMT

Roy, There is an even simpler way of doing this using .Net 2 and TransactionScope - see http://www.bbits.co.uk/blog/archive/2006/07/31/12741.aspx for details. Cheers Ian

re: Simplified Database Unit testing using Enterprise Services

Colin Jack — Mon, 24 Jul 2006 16:59:13 GMT

I've tried using this, specifically using the DataRollbackAttribute, but keep getting wierd MSDTC Transaction Errors: http://groups.google.co.uk/group/microsoft.public.dotnet.framework.component_services/browse_thread/thread/ae13b44beda812e5/29b5c9dfc68003fb?lnk=st&q=&rnum=1&hl=en#29b5c9dfc68003fb The only thing I didn't include in that post was that some of the errors have the code XACT_E_NOTRANSACTION in them. Anyway I found one other post on the newsgroups from someone who was trying to use the ES approach and had the same issue so I wondered if anyone else has seen it and/or solved it?

re: Simplified Database Unit testing using Enterprise Services

Yale — Wed, 21 Jun 2006 15:33:32 GMT

if i have local transactions in the code, the test gives me error: System.InvalidOperationException: OracleConnection does not support parallel transactions

re: Simplified Database Unit testing using Enterprise Services

Yale — Tue, 20 Jun 2006 19:13:18 GMT

in my code i have transactions, my test code gives me error saying: "OracleConnection does not support parallel transactions."

NUint的使用二 [原创]

TrackBack — Wed, 23 Feb 2005 20:57:00 GMT

Ping Back来自：blog.csdn.net