Skip to content

Instantly share code, notes, and snippets.

@serializable
serializable / AsyncSqlTestService.svc.cs
Created June 18, 2011 10:45
WCF ASync to Sql Test Service
public class AsyncSqlTestService : IAsyncSqlTestService
{
public int DoStuffSynchronously(int value)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["testDatabase"].ConnectionString))
{
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.Serializable))
{
using (var cmd = new SqlCommand("waitfor delay '00:00:08'", conn, tran))