通过.Net中的Web服务调用维护SQL事务

How do I perform a database transaction where I create a new record then make a call to a web service using the new record ID returned from the database which will also manipulate the same database? I could obviously update all tables directly from the same SQLConnection object but the logic within the web service call is subject to change and I really need to ensure that the changes my code makes are committed alongside those changes introduced by the called web service.How do I perform a database transaction where I