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