title: Stored Procedure without transaction in Entity Framework
body: <p>I'm calling a stored procedure in Entity Framework 6 that can create Databases and tables if necessary. It is throwing the error; </p>
  
  <blockquote>
    <p>Message    "CREATE DATABASE statement not allowed within multi-statement transaction.\r\nALTER DATABASE statement not allowed within multi-statement transaction.\r\nDatabase 'CoreSnapshotJS3' does not exist. Make sure that the name is entered correctly." string</p>
  </blockquote>
  
  <p>I do not want it in a transaction, and have used this to supress the transaction </p>
  
  <pre><code>using (var transation = new TransactionScope(TransactionScopeOption.Suppress))
  {
      return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("spCreateSnapshotFromQueue", snapshotQueueIDParameter);    
  }
  </code></pre>
  
  <p>It still throws an error.</p>
  
  <p>How do I stop automatic transactions?</p>