private void CreateIfNotExists(DBObject.Configuration configuration) { string query = UseTableNameFix ? "SELECT * FROM \"tblConfiguration\" WHERE name='" : "SELECT * FROM tblConfiguration WHERE name='"; if (_database.Query <DBObject.Configuration>(query + configuration.name + "'").Count() == 0) { _database.Insert("tblConfiguration", "name", configuration); } }
public void Initialise() { DBObject.Configuration configuration = new DBObject.Configuration(); _database.BeginTransaction(); configuration.name = "copyright"; configuration.value = "Joe Bloggs"; CreateIfNotExists(configuration); configuration.name = "export folder"; configuration.value = "c:\\"; CreateIfNotExists(configuration); configuration.name = "overwrite"; configuration.value = "false"; CreateIfNotExists(configuration); _database.CompleteTransaction(); }