public void Can_Get_Data_From_In_Memory_Instance()
        {
            var database = new SqlLiteDbUnitTest(_connection);

            database.ReadXmlSchema(XmlTestFiles.Sqlite.XmlSchemaFile);
            database.ReadXml(XmlTestFiles.Sqlite.XmlFile);

            database.PerformDbOperation(DbOperationFlag.CleanInsertIdentity);

            var command = _connection.CreateCommand();
            command.CommandText = "Select * from [Role]";

            var results = command.ExecuteReader();

            Assert.IsTrue(results.HasRows);

            int recordCount = 0;

            while (results.Read())
            {
                recordCount++;
                Debug.WriteLine(results.GetString(1));
            }

            Assert.AreEqual(2, recordCount);
        }
        public NdbUnitFixture()
        {
            ObjectFactory.Initialize(x =>
                            x.Scan(scan =>
                                    {
                                        scan.AssemblyContainingType<Employee>();
                                        scan.WithDefaultConventions();
                                        scan.LookForRegistries();
                                    })

                );

            ObjectFactory.AssertConfigurationIsValid();

            var session = ObjectFactory.GetInstance<ISession>();

            var dbunitTest = new SqlLiteDbUnitTest(session.Connection);

            dbunitTest.ReadXmlSchema(@"NDbunit\EmployeeApplication.xsd");
            dbunitTest.ReadXml(@"NDbunit\EmployeeApplication.xml");
            dbunitTest.PerformDbOperation(DbOperationFlag.CleanInsert);
        }