title: How to use SQL membership with transaction scope (without DTC)?
body: <p>I'm trying to create a user using the SQL membership provider on <strong>SQL Express</strong>. When I use the <code>TransactionScope</code> it prompts to DTC with no apparent reason, how can I avoid it?</p>
  
  <p>Here is my example code:</p>
  
  <pre><code>using (var ts = new TransactionScope())
  {
      MembershipCreateStatus status;
      Membership.CreateUser(username, password, null, null, null, true, out status);
  
      var userProfile = ProfileBase.Create(username);
  
      userProfile.SetPropertyValue("Fullname", fullname);
      userProfile.Save();
  
      ts.Complete();
  }
  </code></pre>
  
  <p>BTW, I checked in reflector and every membership SQL function always closes its connection.</p>