public void CopyCustomerCustomerDemo() { //Processing CustomerCustomerDemo LogMessage("Reading CustomerCustomerDemo...", false); CustomerCustomerDemoTableAdapter adapter1 = new CustomerCustomerDemoTableAdapter(); NorthwindDb4o.NorthwindDataSet.CustomerCustomerDemoDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.CustomerCustomerDemoRow row in table1) { LogMessage("CustomerCustomerDemo: " + row.CustomerID.ToString() + "/" + row.CustomerTypeID.ToString() + " ...", false); CustomerCustomerDemo ccd = new CustomerCustomerDemo(); LogMessage("linking members...", false); ccd.CustomerID = (Customer)Db4oUtil.GetByStringID(container, typeof(Customer), "customerID",row.CustomerID); ccd.CustomerTypeID = (CustomerDemographics)Db4oUtil.GetByStringID(container, typeof(CustomerDemographics), "customerTypeID", row.CustomerTypeID); container.Store(ccd); LogMessage("saved (" + ccd.CustomerID.CustomerID.ToString() + "/" + ccd.CustomerTypeID.CustomerTypeID.ToString() + ")", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(CustomerCustomerDemo)).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 CustomerCustomerDemo" + Environment.NewLine, true); }
private void CopyCustomerCustomerDemo(IOdb odb) { //Processing CustomerCustomerDemo LogMessage("Reading CustomerCustomerDemo...", false); var adapter1 = new CustomerCustomerDemoTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("CustomerCustomerDemo: " + row.CustomerID + "/" + row.CustomerTypeID + " ...", false); var ccd = new CustomerCustomerDemo(); LogMessage("linking members...", false); ccd.CustomerID = NDbUtil.GetByStringID <Customer>(odb, Customer.PK, row.CustomerID); ccd.CustomerTypeID = NDbUtil.GetByStringID <CustomerDemographics>(odb, CustomerDemographics.PK, row.CustomerTypeID); odb.Store(ccd); LogMessage("saved (" + ccd.CustomerID.CustomerID + "/" + ccd.CustomerTypeID.CustomerTypeID + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances <CustomerCustomerDemo>(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 CustomerCustomerDemo" + Environment.NewLine, true); }
private void CopyCustomerCustomerDemo(IOdb odb) { //Processing CustomerCustomerDemo LogMessage("Reading CustomerCustomerDemo...", false); var adapter1 = new CustomerCustomerDemoTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("CustomerCustomerDemo: " + row.CustomerID + "/" + row.CustomerTypeID + " ...", false); var ccd = new CustomerCustomerDemo(); LogMessage("linking members...", false); ccd.CustomerID = NDbUtil.GetByStringID<Customer>(odb, Customer.PK, row.CustomerID); ccd.CustomerTypeID = NDbUtil.GetByStringID<CustomerDemographics>(odb, CustomerDemographics.PK, row.CustomerTypeID); odb.Store(ccd); LogMessage("saved (" + ccd.CustomerID.CustomerID + "/" + ccd.CustomerTypeID.CustomerTypeID + ")", true); } odb.Commit(); long objectCount = NDbUtil.GetAllInstances<CustomerCustomerDemo>(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 CustomerCustomerDemo" + Environment.NewLine, true); }