public void InsertDatasTest()
        {
            string       connectStr = @"Data Source=(LOCALDB)\MSSQLLOCALDB;Initial Catalog=UnitTest;Integrated Security=True";
            int          count;
            const string identity = "1234567890";
            const int    times    = 123;
            List <NoInsertCharNullTestStructForDbTableManager> datas = new List <NoInsertCharNullTestStructForDbTableManager>();

            for (int i = 0; i < times; i++)
            {
                NoInsertCharNullTestStructForDbTableManager noCharNullTestStruct = new NoInsertCharNullTestStructForDbTableManager();
                const string testvalue = "1234";
                noCharNullTestStruct.id            = 1;
                noCharNullTestStruct.intC          = 1;
                noCharNullTestStruct.varchar10     = identity;
                noCharNullTestStruct.varcharNull10 = testvalue;
                noCharNullTestStruct.datetime      = DateTime.Now;
                noCharNullTestStruct.datetimeNull  = DateTime.Now;
                datas.Add(noCharNullTestStruct);
            }

            try
            {
                DbTableManager <NoInsertCharNullTestStructForDbTableManager> .Insert(datas, connectStr);

                count = DbQuery <int> .GetData(connectStr, "select Count(1) from " + datas[0].GetTableName() + " where varchar10 = '" + identity + "'")[0];

                Assert.AreEqual(count, times);
            }
            catch (Exception e)
            {
                Assert.Fail();
            }
            finally
            {
                DbQuery.Exc(connectStr, "delete test");
            }
        }
        public void InsertDataTest()
        {
            string       connectStr = @"Data Source=(LOCALDB)\MSSQLLOCALDB;Initial Catalog=UnitTest;Integrated Security=True";
            int          count;
            const string identity = "1234567890";
            ErrTestStructForDbTableManager errTestStruct = new ErrTestStructForDbTableManager();

            errTestStruct.id            = 1;
            errTestStruct.intC          = 1;
            errTestStruct.varchar10     = identity;
            errTestStruct.varcharNull10 = "";
            errTestStruct.datetime      = DateTime.Now;
            errTestStruct.datetimeNull  = DateTime.Now;

            try
            {
                DbTableManager <ErrTestStructForDbTableManager> .Insert(errTestStruct, connectStr);

                Assert.Fail();
            }
            catch
            {
                count = DbQuery <int> .GetData(connectStr, "select count(1) from " + errTestStruct.GetTableName() + " where varchar10 = '" + identity + "'")[0];

                Assert.AreEqual(count, 0);
            }
            finally
            {
                DbQuery.Exc(connectStr, "delete test");
            }

            TestStructForDbTableManager testStruct = new TestStructForDbTableManager();

            testStruct.id            = 1;
            testStruct.intC          = 1;
            testStruct.varchar10     = identity;
            testStruct.varcharNull10 = "";
            testStruct.datetime      = DateTime.Now;
            testStruct.datetimeNull  = DateTime.Now;

            try
            {
                DbTableManager <TestStructForDbTableManager> .Insert(testStruct, connectStr);

                count = DbQuery <int> .GetData(connectStr, "select count(1) from " + errTestStruct.GetTableName() + " where varchar10 = '" + identity + "'")[0];

                Assert.AreEqual(count, 1);
            }
            catch (Exception e)
            {
                Assert.Fail();
            }
            finally
            {
                DbQuery.Exc(connectStr, "delete test");
            }

            NoInsertCharNullTestStructForDbTableManager noCharNullTestStruct = new NoInsertCharNullTestStructForDbTableManager();
            const string testvalue = "1234";

            noCharNullTestStruct.id            = 1;
            noCharNullTestStruct.intC          = 1;
            noCharNullTestStruct.varchar10     = identity;
            noCharNullTestStruct.varcharNull10 = testvalue;
            noCharNullTestStruct.datetime      = DateTime.Now;
            noCharNullTestStruct.datetimeNull  = DateTime.Now;

            try
            {
                DbTableManager <NoInsertCharNullTestStructForDbTableManager> .Insert(noCharNullTestStruct, connectStr);

                string value = DbQuery <string> .GetData(connectStr, "select varcharNull10 from " + noCharNullTestStruct.GetTableName() + " where varchar10 = '" + identity + "'")[0];

                Assert.AreEqual(value, null);
            }
            catch (Exception e)
            {
                Assert.Fail();
            }
            finally
            {
                DbQuery.Exc(connectStr, "delete test");
            }
        }