Code First Database Generation Error

I have a very simple test project based on the CodeFirstWalk in Silverlight with a connection string in web.config to Sql Server.

When I fire it up and run it, when there is no existing database, it throws the following error:

System.Data.SqlClient.SqlException: CREATE DATABASE statement not allowed within multi-statement transaction.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

The odd part of this is that the database is in fact created, and the data properly saved to the database.

After the first run, there is no error as of course the database is already there and additional data is saved.

The code is very straightforward:

public class ProductEntities : EntityManager {
        public EntityQuery<Category> Categories { get; set; }
    }

    [ProvideEntityAspect]
    public class Category
    {
        public int CategoryId { get; set; }
        public string CategoryName { get; set; }
    }


public class MainPageViewModel
    {

        private ProductEntities Manager { get; set; }

        public MainPageViewModel() {
            SetManager();
            AddTestData();
        }

        private void AddTestData()
        {
            var cat = new Category { CategoryName = "Sweet Things on " + DateTime.Now.ToString("o") };
            Manager.AddEntity(cat);
            Manager.SaveChangesAsync();
        }

        private void SetManager()
        {
            Manager = new ProductEntities();
            Manager.EntityServerError += (s, e) =>
            {
               e.Handled = true; // we're dealing with it here
               MessageBox.Show(e.Exception.Message);
               Manager.RejectChanges(); // undo pending changes
            };
            Manager.SaveChangesAsync();
        }


    }

This is not a big issue, it just makes no sense to me.

Greg

Sql Server 2008 R2 and DevForce 7.0.3

But I think I know the issue - what was kicking off the database creation was adding an Entity and then saving it.

When I changed the kickoff to a query, then it ran without error. I think somehow the Database Creation and the save operation were somehow getting wrapped up into one transaction.

But this is resolved as far as I am concerned.

Greg