public static void PurgeDb(Seed seed)
        {
            ConnectionProfile cp = new ConnectionProfile();
            SqlConnectionStringBuilder conn_orig = new SqlConnectionStringBuilder(cp.ConnectionString);
            SqlConnectionStringBuilder conn = new SqlConnectionStringBuilder(cp.ConnectionString) { ConnectTimeout = 5, InitialCatalog = "master" }; // you can add other parameters.
            using (SqlConnection cnn = new SqlConnection(conn.ConnectionString))
            {
                cnn.Open();

                using (SqlCommand dbCreate = new SqlCommand())
                {
                    dbCreate.CommandText = string.Format(@"IF db_id('{0}') IS NULL CREATE DATABASE [{0}]", conn_orig.InitialCatalog);
                    dbCreate.Connection = cnn;
                    try
                    {
                        dbCreate.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(string.Format("create database [{0}] FAILED with {1}", conn_orig.InitialCatalog, ex.Message ));
                    }
                }
            }

            seed.PurgeDb();
        }
Exemple #2
0
        void before_each()
        {
            seed = new Seed();

            blogs = new Blogs();

            comments = new Comments();
        }
 static void Main(string[] args)
 {
     ConnectionProfile.connectionString = @"Server=(localdb)\ProjectsV12; Database=SyncToday2015.new; Trusted_Connection=True;";
     if (args.Length >0) ConnectionProfile.connectionString = args[0];
     //Console.WriteLine(string.Format("Creating database '{0}'", ConnectionProfile.connectionString));
     var seed = new Seed();
     PurgeDb(seed);
     var schema = new Schema(seed);
     schema.Scripts().ForEach<dynamic>(s => { /*Console.WriteLine(s());*/ seed.ExecuteNonQuery(s()); });
 }
Exemple #4
0
 public string CreateUserTable(Seed seed)
 {
     return seed.CreateTable("Users",
         new { Id = "int", Identity = true, PrimaryKey = true },
         new { Email = "nvarchar(max)" },
         new { FirstName = "nvarchar(max)" },
         new { LastName = "nvarchar(max)" },
         new { Password = "******" }
     );
 }
Exemple #5
0
        static void Main(string[] args)
        {
            if (args.Length == 0) throw new InvalidOperationException("first argument should be a connection string.");

            Console.WriteLine("Purging and regenerating schema for " + args[0] + ".");

            var connection = new ConnectionProfile { ConnectionString = args[0] };

            var seed = new Seed(connection);

            var schema = new Schema(seed);

            seed.PurgeDb();

            seed.ExecuteTo(schema.Scripts(), schema.Current());

            Console.WriteLine("Done.");
        }
Exemple #6
0
 public Schema(Seed seed)
 {
     Seed = seed;
 }
Exemple #7
0
        public SeedController()
        {
            Seed = new Seed();

            Schema = new Schema(Seed);
        }
Exemple #8
0
 void before_each()
 {
     seed = new Seed();
 }
        void SetupSchema()
        {
            seed = new Seed();

            seed.PurgeDb();

            seed.CreateTable("Blogs", new dynamic[]
            {
                new { Id = "int", Identity = true, PrimaryKey = true },
                new { Title = "nvarchar(255)" },
                new { Body = "nvarchar(max)" }
            }).ExecuteNonQuery();

            seed.CreateTable("Comments", new dynamic[]
            {
                new { Id = "int", Identity = true, PrimaryKey = true },
                new { BlogId = "int", ForeignKey = "Blogs(Id)" },
                new { Text = "nvarchar(1000)" }
            }).ExecuteNonQuery();
        }
Exemple #10
0
 public Schema(Seed seed)
 {
     this.seed = seed;
 }
Exemple #11
0
 public SeedController()
 {
     Seed = new Seed();
 }