static void Main(string[] args) { var customers = new ShopDB.CustomersDataTable(); var customersTableAdapter = new CustomersTableAdapter(); customersTableAdapter.ClearBeforeFill = true; customersTableAdapter.Insert("test", "test", "test", "test", "test", "test", "test", new DateTime(9999 / 12 / 31)); //var insertedRowNumber = customersTableAdapter.Insert("test", "test", "test", "test", "test", "test", "test", new DateTime(9999 / 12 / 31)); customers = customersTableAdapter.GetData(); DataRow[] testRows = customers.Select("Phone='test'"); foreach (DataRow testRow in testRows) { foreach (DataColumn column in customers.Columns) { Console.WriteLine($"{column.ColumnName}: {testRow[column]}"); } Console.WriteLine(); } //now we're going to delete rows with test phone numbers Console.WriteLine(new string('*', 30)); Console.WriteLine($"Total test row(s) deleted: {DeleteTestRows()}"); //customersTableAdapter.Delete(insertedRowNumber); //doesn't work with sole int customers = customersTableAdapter.GetData(); testRows = customers.Select("Phone = 'test'"); foreach (DataRow testRow in testRows) { foreach (DataColumn column in customers.Columns) { Console.WriteLine($"{column.ColumnName}: {testRow[column]}"); } } Console.ReadKey(); }
private void CopyCustomers(IOdb odb) { //Processing Customers LogMessage("Reading Customers...", false); var adapter1 = new CustomersTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Customer: " + row.CustomerID + " ...", false); var c = new Customer { CustomerID = row.CustomerID, CompanyName = row.CompanyName, ContactName = row.IsContactNameNull() ? null : row.ContactName, ContactTitle = row.IsContactTitleNull() ? null : row.ContactTitle, Address = row.IsAddressNull() ? null : row.Address, City = row.IsCityNull() ? null : row.City, Region = row.IsRegionNull() ? null : row.Region, PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode, Country = row.IsCountryNull() ? null : row.Country, Phone = row.IsPhoneNull() ? null : row.Phone, Fax = row.IsFaxNull() ? null : row.Fax }; odb.Store(c); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor <Customer>().AddUniqueIndexOn("Customer_CustomerID_PK_index", Customer.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances <Customer>(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 Customers" + Environment.NewLine, true); }
static void Main(string[] args) { var customersTableAdapter = new CustomersTableAdapter(); var customers = customersTableAdapter.GetData(); //creates a customersdatatable foreach (DataRow row in customers.Rows) { foreach (DataColumn column in customers.Columns) { Console.WriteLine($"{column.ColumnName}: {row[column]}"); } Console.WriteLine(); } Console.ReadKey(); }
public void CopyCustomers() { //Processing Customers LogMessage("Reading Customers...", false); CustomersTableAdapter adapter1 = new CustomersTableAdapter(); NorthwindDb4o.NorthwindDataSet.CustomersDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.CustomersRow row in table1) { LogMessage("Customer: " + row.CustomerID.ToString() + " ...", false); Customer c = new Customer(); c.CustomerID = row.CustomerID; c.CompanyName = row.CompanyName; c.ContactName = row.IsContactNameNull() ? null : row.ContactName; c.ContactTitle = row.IsContactTitleNull() ? null : row.ContactTitle; c.Address = row.IsAddressNull() ? null : row.Address; c.City = row.IsCityNull() ? null : row.City; c.Region = row.IsRegionNull() ? null : row.Region; c.PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode; c.Country = row.IsCountryNull() ? null : row.Country; c.Phone = row.IsPhoneNull() ? null : row.Phone; c.Fax = row.IsFaxNull() ? null : row.Fax; container.Store(c); LogMessage("saved", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(Customer)).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 Customers" + Environment.NewLine, true); }
private void CopyCustomers(IOdb odb) { //Processing Customers LogMessage("Reading Customers...", false); var adapter1 = new CustomersTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Customer: " + row.CustomerID + " ...", false); var c = new Customer { CustomerID = row.CustomerID, CompanyName = row.CompanyName, ContactName = row.IsContactNameNull() ? null : row.ContactName, ContactTitle = row.IsContactTitleNull() ? null : row.ContactTitle, Address = row.IsAddressNull() ? null : row.Address, City = row.IsCityNull() ? null : row.City, Region = row.IsRegionNull() ? null : row.Region, PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode, Country = row.IsCountryNull() ? null : row.Country, Phone = row.IsPhoneNull() ? null : row.Phone, Fax = row.IsFaxNull() ? null : row.Fax }; odb.Store(c); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor<Customer>().AddUniqueIndexOn("Customer_CustomerID_PK_index", Customer.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances<Customer>(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 Customers" + Environment.NewLine, true); }