private void CopyEmployeeTerritories(IOdb odb) { //Processing EmployeeTerritories LogMessage("Reading EmployeeTerritories...", false); var adapter1 = new EmployeeTerritoriesTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID + " ...", false); var et = new EmployeeTerritory(); LogMessage("linking members...", false); et.Employee = NDbUtil.GetByNumericalID <Employee>(odb, Employee.PK, row.EmployeeID); et.Territory = NDbUtil.GetByStringID <Territory>(odb, Territory.PK, row.TerritoryID); odb.Store(et); LogMessage("saved (" + et.Employee.EmployeeID.ToString() + "/" + et.Territory.TerritoryID + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances <EmployeeTerritory>(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 EmployeeTerritories" + Environment.NewLine, true); }
public void CopyEmployeeTerritories() { //Processing EmployeeTerritories LogMessage("Reading EmployeeTerritories...", false); EmployeeTerritoriesTableAdapter adapter1 = new EmployeeTerritoriesTableAdapter(); NorthwindDb4o.NorthwindDataSet.EmployeeTerritoriesDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.EmployeeTerritoriesRow row in table1) { LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID.ToString() + " ...", false); EmployeeTerritory et = new EmployeeTerritory(); LogMessage("linking members...", false); et.EmployeeID = (Employee)Db4oUtil.GetByNumericalID(container, typeof(Employee), "employeeID", row.EmployeeID); et.TerritoryID = (Territory)Db4oUtil.GetByStringID(container, typeof(Territory), "territoryID", row.TerritoryID); container.Store(et); LogMessage("saved (" + et.EmployeeID.EmployeeID.ToString() + "/" + et.TerritoryID.TerritoryID.ToString() + ")", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(EmployeeTerritory)).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 EmployeeTerritories" + Environment.NewLine, true); }
private void CopyEmployeeTerritories(IOdb odb) { //Processing EmployeeTerritories LogMessage("Reading EmployeeTerritories...", false); var adapter1 = new EmployeeTerritoriesTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID + " ...", false); var et = new EmployeeTerritory(); LogMessage("linking members...", false); et.Employee = NDbUtil.GetByNumericalID<Employee>(odb, Employee.PK, row.EmployeeID); et.Territory = NDbUtil.GetByStringID<Territory>(odb, Territory.PK, row.TerritoryID); odb.Store(et); LogMessage("saved (" + et.Employee.EmployeeID.ToString() + "/" + et.Territory.TerritoryID + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances<EmployeeTerritory>(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 EmployeeTerritories" + Environment.NewLine, true); }