public int getTaxa(string source, string target)
{
//Alte DB-Einträge löschen
string connString = "Data Source=\"" + sdfPath + "\";Max Database Size=128;Default Lock Escalation=100;";
SqlCeConnection conn = new SqlCeConnection(connString);
DbCommand command = conn.CreateCommand();
conn.Open();
StringBuilder sb = new StringBuilder();
sb.Append("Delete From ").Append(target);
command.CommandText = sb.ToString();
command.ExecuteNonQuery();
conn.Close();
//Neue Taxa holen
List <TaxonNames> taxa = new List <TaxonNames>();
DbCommand com = ConnRepository.CreateCommand();
sb = new StringBuilder();
sb.Append("Select * From ").Append(source);
com.CommandText = sb.ToString();
ConnRepository.Open();
DbDataReader reader = com.ExecuteReader();
while (reader.Read())
{
TaxonNames taxon = SerRepository.CreateISerializableObject <TaxonNames>();
taxon.NameURI = reader.GetString(0);
taxon.TaxonNameCache = reader.GetString(1);
taxon.Synonym = reader.GetString(2);
taxa.Add(taxon);
}
ConnRepository.Close();
SerMobile.Connector.BeginTransaction();
foreach (TaxonNames taxon in taxa)
{
SerMobile.Connector.InsertPlain(taxon, target);
}
SerMobile.Connector.Commit();
return(taxa.Count);
}
