private void CopyShippers(IOdb odb) { //Processing Shippers LogMessage("Reading Shippers...", false); var adapter1 = new ShippersTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Shippers: " + row.ShipperID.ToString() + " ...", false); var s = new Shipper { ShipperID = row.ShipperID, CompanyName = row.CompanyName, Phone = row.IsPhoneNull() ? null : row.Phone }; odb.Store(s); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor <Shipper>().AddUniqueIndexOn("Shipper_ShipperID_PK_index", Shipper.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances <Shipper>(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 Shippers" + Environment.NewLine, true); }
public void CopyShippers() { //Processing Shippers LogMessage("Reading Shippers...", false); ShippersTableAdapter adapter1 = new ShippersTableAdapter(); NorthwindDb4o.NorthwindDataSet.ShippersDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.ShippersRow row in table1) { LogMessage("Shippers: " + row.ShipperID.ToString() + " ...", false); Shipper s = new Shipper(); s.ShipperID = row.ShipperID; s.CompanyName = row.CompanyName; s.Phone = row.IsPhoneNull() ? null : row.Phone; container.Store(s); LogMessage("saved", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(Shipper)).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 Shippers" + Environment.NewLine, true); }
private void CopyShippers(IOdb odb) { //Processing Shippers LogMessage("Reading Shippers...", false); var adapter1 = new ShippersTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Shippers: " + row.ShipperID.ToString() + " ...", false); var s = new Shipper { ShipperID = row.ShipperID, CompanyName = row.CompanyName, Phone = row.IsPhoneNull() ? null : row.Phone }; odb.Store(s); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor<Shipper>().AddUniqueIndexOn("Shipper_ShipperID_PK_index", Shipper.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances<Shipper>(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 Shippers" + Environment.NewLine, true); }