Signum Framework Tutorials Part 3 - Southwind Load

using System;
using System.Linq;
using System.Collections.Generic;
using System.Text.RegularExpressions;
using Signum.Engine;
using Signum.Engine.Maps;
using Signum.Utilities;
using Southwind.Load.Properties;
using Southwind.Logic;
using Southwind.Entities;
using Signum.Services;
using Signum.Entities;

namespace Southwind.Load
{
    class Program
    {
        static void Main(string[] args)
        {
            using (Sync.ChangeCulture("en"))
            using (Sync.ChangeCultureUI("en"))
            {
            Starter.Start(Settings.Default.ConnectionString);

            Console.WriteLine("..:: Welcome to Southwind Loading Application ::..");
            Console.WriteLine("Database: {0}", Regex.Match(((Connection)ConnectionScope.Current).ConnectionString, @"Initial Catalog\=(?<db>.*)\;").Groups["db"].Value);
            Console.WriteLine();

            while (true)
            {
                Action action = new ConsoleSwitch<string, Action>
                {
                    {"N", NewDatabase},
                    {"S", Synchronize},
                    {"L", null, "Load"},
                }.Choose();

                if (action == null)
                    break;

                action();
            }

            Schema.Current.InitializeUntil(InitLevel.Level0SyncEntities);

            while (true)
            {
                Action[] actions = new ConsoleSwitch<int, Action>
                {
                        {0, EmployeeLoader.LoadRegions},
                        {1, EmployeeLoader.LoadTerritories},
                        {2, EmployeeLoader.LoadEmployees},
                        {3, ProductLoader.LoadSuppliers },
                        {4, ProductLoader.LoadCategories },
                        {5, ProductLoader.LoadProducts },
                        {6, CustomerLoader.LoadCompanies },
                        {7, CustomerLoader.LoadPersons },
                        {8, OrderLoader.LoadShippers },
                        {9, OrderLoader.LoadOrders },
                }.ChooseMultiple();

                if (actions == null)
                    return;

                foreach (var acc in actions)
                {
                    Console.WriteLine("------- Executing {0} ".Formato(acc.Method.Name.SpacePascal(true)).PadRight(Console.WindowWidth - 2, '-'));
                    acc();
                }
            }
        }
        }

        public static void NewDatabase()
        {
            Console.WriteLine("You will lose all your data. Sure? (Y/N)");
            string val = Console.ReadLine();
            if (!val.StartsWith("y") && !val.StartsWith("Y"))
                return;

            Console.Write("Creating new database...");
            Administrator.TotalGeneration();
            Console.WriteLine("Done.");
        }

        static void Synchronize()
        {
            Console.WriteLine("Check and Modify the synchronization script before");
            Console.WriteLine("executing it in SQL Server Management Studio: ");
            Console.WriteLine();

            SqlPreCommand command = Administrator.TotalSynchronizeScript();
            if (command == null)
            {
                Console.WriteLine("Already synchronized!");
                return;
            }

            command.OpenSqlFileRetry();
        }
    }
}