public void ShouldThrowIfDatabaseIsNotSet()
        {
            SqlServerConnectionSettings s = new SqlServerConnectionSettings();

            s.ServerName = "localhost";
            string temp = s.ConnectionString;
        }
        public void ShouldThrowIfServerIsNotSet()
        {
            SqlServerConnectionSettings s = new SqlServerConnectionSettings();

            s.Database = "Northwind";
            string temp = s.ConnectionString;
        }
        public void ShouldCreateAdventureWorksConnectionStringOnLocalHost()
        {
            SqlServerConnectionSettings s = new SqlServerConnectionSettings("localhost", "AdventureWorks");

            s.Password = "******";
            s.UserName = "******";

            Assert.AreEqual("localhost", s.ServerName);
            Assert.AreEqual("AdventureWorks", s.Database);
            Assert.AreEqual("SQL", s.DriverType);
            Assert.AreEqual("Provider=SQLOLEDB.1; Data Source=localhost; Initial Catalog=AdventureWorks; User ID=me; Password=PASS", s.ConnectionString);
        }
Example #4
0
        public void SetUp()
        {
            string server    = ConfigurationManager.AppSettings["server"];
            string database1 = ConfigurationManager.AppSettings["database1"];

            connSettings = new SqlServerConnectionSettings(server, database1);

            // TODO: remove this
            connSettings.UserName = "******";
            connSettings.Password = "******";

            customerXmlPath = AppDomain.CurrentDomain.BaseDirectory + @"\..\..\Scripts\Customer.xml";
        }
Example #5
0
        public void SetUp()
        {
            engine = new MigrationEngine(new SqlServerScriptBuilder(), new DatabaseComparer());

            ScriptMessageManager msgMgr = new ScriptMessageManager();

            engine.MessageManager = msgMgr;
            msgMgr.ScriptMessage += delegate(object src, ScriptMessageEventArgs e)
            {
                Console.WriteLine(e.Message);
            };

            string server   = ConfigurationManager.AppSettings["server"];
            string database = ConfigurationManager.AppSettings["database"];

            connectionSettings          = new SqlServerConnectionSettings(server, database);
            connectionSettings.UserName = "******";
            connectionSettings.Password = "******";
        }
Example #6
0
        public void SetUp()
        {
            engine = new MigrationEngine(new SqlServerScriptBuilder(), new DatabaseComparer());

            ScriptMessageManager msgMgr = new ScriptMessageManager();

            engine.MessageManager = msgMgr;
            msgMgr.ScriptMessage += delegate(object src, ScriptMessageEventArgs e)
            {
                Console.WriteLine(e.Message);
            };

            string server = ConfigurationManager.AppSettings["server"];

            string database1 = ConfigurationManager.AppSettings["database1"];
            string database2 = ConfigurationManager.AppSettings["database2"];

            connSettings1 = new SqlServerConnectionSettings(server, database1);
            connSettings2 = new SqlServerConnectionSettings(server, database2);
        }