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();
}
