private void CopyTerritories(IOdb odb)
{
//Processing Territories
LogMessage("Reading Territories...", false);
var adapter1 = new TerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Territories: " + row.TerritoryID + " ...", false);
var t = new Territory {
TerritoryID = row.TerritoryID, TerritoryDescription = row.TerritoryDescription
};
LogMessage("linking member...", false);
t.Region = NDbUtil.GetByNumericalID <Region>(odb, Domain.Region.PK, row.RegionID);
odb.Store(t);
LogMessage("saved (" + t.TerritoryID + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Territory>().AddUniqueIndexOn("Territory_TerritoryID_PK_index", Territory.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Territory>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Territories" + Environment.NewLine, true);
}
public void CopyTerritories()
{
//Processing Territories
LogMessage("Reading Territories...", false);
TerritoriesTableAdapter adapter1 = new TerritoriesTableAdapter();
NorthwindDb4o.NorthwindDataSet.TerritoriesDataTable table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (NorthwindDb4o.NorthwindDataSet.TerritoriesRow row in table1)
{
LogMessage("Territories: " + row.TerritoryID.ToString() + " ...", false);
Territory t = new Territory();
t.TerritoryID = row.TerritoryID;
t.TerritoryDescription = row.TerritoryDescription;
LogMessage("linking member...", false);
t.RegionID = (Region)Db4oUtil.GetByNumericalID(container, typeof(Region), "regionID", row.RegionID);
container.Store(t);
LogMessage("saved (" + t.TerritoryID.ToString() + ")", true);
}
container.Commit();
long objectCount = Db4oUtil.GetAllInstances(container, typeof(Territory)).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Territories" + Environment.NewLine, true);
}
private void CopyTerritories(IOdb odb)
{
//Processing Territories
LogMessage("Reading Territories...", false);
var adapter1 = new TerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Territories: " + row.TerritoryID + " ...", false);
var t = new Territory {TerritoryID = row.TerritoryID, TerritoryDescription = row.TerritoryDescription};
LogMessage("linking member...", false);
t.Region = NDbUtil.GetByNumericalID<Region>(odb, Domain.Region.PK, row.RegionID);
odb.Store(t);
LogMessage("saved (" + t.TerritoryID + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Territory>().AddUniqueIndexOn("Territory_TerritoryID_PK_index", Territory.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Territory>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Territories" + Environment.NewLine, true);
}
