public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception_When_Schema_Has_Prefix() { var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString); db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests); db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); }
public void Initialize() { // string connectionString = "server=localhost;user=dbuser;password=dbpassword;initial catalog=MyDatabase;"; NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString); mySqlDatabase.ReadXmlSchema(@"DBFixtures/JewelryItems.xsd"); mySqlDatabase.ReadXml(@"DBFixtures/JewelryItemsAllCategories.xml"); mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); settingManager = MockRepository.GenerateStub <ISettingManager>(); }
public void Initialize() { // string connectionString = "server=localhost;user=dbuser;password=dbpassword;initial catalog=MyDatabase;"; NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString); mySqlDatabase.ReadXmlSchema(@"DBFixtures/JewelryItems.xsd"); mySqlDatabase.ReadXml(@"DBFixtures/JewelryItemsAllCategories.xml"); mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); settingManager = MockRepository.GenerateStub<ISettingManager>(); }
public static void TestInit(TestContext testContext) { const string xmlSchemaPath = @"..\..\DummyData\DummyDataSchema.xsd"; const string xmlSourcePath = @"..\..\DummyData\DummyDataSource.xml"; var connectionString = ConfigurationManager.ConnectionStrings["ArinnaTestContext"].ToString(); NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString); mySqlDatabase.ReadXmlSchema(xmlSchemaPath); mySqlDatabase.ReadXml(xmlSourcePath); mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); }
public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception() { try { var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString); db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests); db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); } catch (Exception) { Assert.Fail("Operation not successful when using tables with Schema Prefixes."); } }
public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception_When_Schema_Has_Prefix() { try { var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString); db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests); db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); } catch (Exception) { Assert.Fail("Operation not successful when using tables with Schema Prefixes."); } }
public void DataSet_Contains_Both_Appended_and_New_Records() { var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString); db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFile); db.ReadXml(XmlTestFiles.SqlServer.XmlFile); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); var preAppendDataset = db.GetDataSetFromDb(); Assert.AreEqual(2, preAppendDataset.Tables["dbo.User"].Rows.Count); Assert.AreEqual(2, preAppendDataset.Tables["Role"].Rows.Count); db.AppendXml(XmlTestFiles.SqlServer.XmlApppendFile); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); var postAppendDataset = db.GetDataSetFromDb(); Assert.AreEqual(4, postAppendDataset.Tables["dbo.User"].Rows.Count); Assert.AreEqual(4, postAppendDataset.Tables["Role"].Rows.Count); }
public void DataSet_Contains_Both_Appended_and_New_Records() { var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString); db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFile); db.ReadXml(XmlTestFiles.SqlServer.XmlFile); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); var preAppendDataset = db.GetDataSetFromDb(null); Assert.AreEqual(2, preAppendDataset.Tables["dbo.User"].Rows.Count); Assert.AreEqual(2, preAppendDataset.Tables["Role"].Rows.Count); db.AppendXml(XmlTestFiles.SqlServer.XmlApppendFile); db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity); var postAppendDataset = db.GetDataSetFromDb(null); Assert.AreEqual(4, postAppendDataset.Tables["dbo.User"].Rows.Count); Assert.AreEqual(4, postAppendDataset.Tables["Role"].Rows.Count); }