コード例 #1
0
        public void 新增一筆()
        {
            var dbConnectString = DataConnection.GetConnectionString(ConnectionName);

            //解密
            dbConnectString = this.Validator.Decrypt(dbConnectString);
            DataConnection.SetConnectionString(ConnectionName, dbConnectString);

            LabEmployee2DB db = null;

            try
            {
                db = new LabEmployee2DB(ConnectionName);
            }
            finally
            {
                db.Close();
                db.Dispose();
            }

            using (db = new LabEmployee2DB(ConnectionName))
            {
                db.OnClosing += this.Db_OnClosing;
                db.OnClosed  += this.Db_OnClosed;
                if (db.Connection.State == ConnectionState.Closed)
                {
                    db.Connection.Open();
                }

                var count = db.Insert(new Employee {
                    Id = Guid.NewGuid(), Name = "小章", Age = 18
                });
                Assert.IsTrue(count == 1);

                db.Connection.Close();
            }

            db.DisposeCommand();
        }