public void CanExecuteNonQueryWithDbCommand() { using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf")) { using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase) { string insertionString = @"insert into TestTable values (5, 'Cinco')"; DbCommand insertionCommand = new SqlCeCommand(); insertionCommand.CommandText = insertionString; database.ExecuteNonQuery(insertionCommand); string countCommand = @"select count(*) from TestTable"; int count = Convert.ToInt32(database.ExecuteScalar(countCommand)); string cleanupString = "delete from TestTable where TestColumn = 5"; DbCommand cleanupCommand = new SqlCeCommand(); cleanupCommand.CommandText = cleanupString; int rowsAffected = database.ExecuteNonQuery(cleanupCommand); Assert.AreEqual(5, count); Assert.AreEqual(1, rowsAffected); } } }
public void WhatGetsReturnedWhenWeDoAnInsertThroughDbCommandExecute() { using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf")) { int count = -1; IDataReader reader = null; using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase) { try { string insertString = @"insert into TestTable values (5, 'Cinco')"; reader = database.ExecuteReader(insertString); count = reader.RecordsAffected; } finally { if (reader != null) { reader.Close(); } string deleteString = "Delete from TestTable where TestColumn = 5"; database.ExecuteNonQuery(deleteString); } Assert.AreEqual(1, count); } } }
public void ExecuteNonQueryThrowsIfNullQueryIsPassed() { using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf")) { using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase) { Assert.AreEqual(1, database.ExecuteNonQuery((string)null, null)); } } }
public void ExecuteNonQueryWithNullStringThrows() { using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf")) { using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase) { database.ExecuteNonQuery((String)null); } } }
public void CanInsertNullStringParameter() { using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf")) { using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase) { string sqlString = "insert into TestTable Values (@Param1, @Param2)"; DbParameter[] parameters = new DbParameter[] { database.CreateParameter("@Param1", DbType.Int32, 0, 5), database.CreateParameter("@Param2", DbType.String, 50, null) }; database.ExecuteNonQuery(sqlString, parameters); string sqlCount = "SELECT COUNT(*) FROM TestTable "; Assert.AreEqual(5, database.ExecuteScalar(sqlCount, null)); } } }