public void MyTestInitialize()
        {
            const string dbScriptFileName = @"\schema.sql";
            string databaseScriptFullPath = TestEnvironment.GetApplicationDirectory() + dbScriptFileName;
            var storageManager = new SqLiteStorageManager();

            _sqliteDtabase = storageManager.InitializeInMemoryStorage(databaseScriptFullPath);
            _repositoryFactory = new RepositoryFactory(storageManager);
            _repositoryFactory.RegisterSpecificationTranslator(new CommonTranslator<Customer>())
                             .RegisterSpecificationTranslator(new ShippingAddressSpecTranslator());
        }
        public void SqLiteDatabaseInMemoryDbTest()
        {
            const string dbScriptFileName = @"\schema.sql";
            string databaseScriptFullPath = TestEnvironment.GetApplicationDirectory() + dbScriptFileName;
            var storageManager = new SqLiteStorageManager();
            var target = storageManager.InitializeInMemoryStorage(databaseScriptFullPath);

            int actualTablesCount = GetDdTablesCount(target);
            const int expectedTablesCount = 17;
            Assert.AreEqual(expectedTablesCount, actualTablesCount);
            target.Dispose();
        }