public void Can_get_all() { IAccountCategoryRepository repository = new AccountCategoryRepository(); var fromDb = repository.GetAll(); Assert.AreEqual(4, fromDb.Count); Assert.IsTrue(IsInCollection(_accountCategories[0], fromDb)); Assert.IsTrue(IsInCollection(_accountCategories[1], fromDb)); Assert.IsTrue(IsInCollection(_accountCategories[2], fromDb)); Assert.IsTrue(IsInCollection(_accountCategories[3], fromDb)); }
private static void ExportAccountCategories(OleDbConnection dbConnection) { OleDbCommand createTable = new OleDbCommand("CREATE TABLE `AccountCategories` (" + "`Name` LongText, " + "`Colour` LongText, " + "`IsValid` LongText" + ")", dbConnection); createTable.ExecuteNonQuery(); AccountCategoryRepository repository = new AccountCategoryRepository(); var accountCategories = repository.GetAll(); foreach (AccountCategory a in accountCategories) { string insertStatement = "INSERT INTO [AccountCategories] ([Name], [Colour], [IsValid]) VALUES ('" + a.Name + "', '" + a.Colour + "', '" + a.IsValid + "')"; OleDbCommand insert = new OleDbCommand(insertStatement, dbConnection); insert.ExecuteNonQuery(); } }