public void CopyRegions(IOdb odb, NorthwindDataSet dataSet) { //Processing Regions LogMessage("Reading Regions...", false); var adapter1 = new RegionTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Regions: " + row.RegionID.ToString() + " ...", false); var r = new Region {RegionID = row.RegionID, RegionDescription = row.RegionDescription}; odb.Store(r); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor<Region>().AddUniqueIndexOn("Region_RegionID_PK_index", Domain.Region.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances<Region>(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 Regions" + Environment.NewLine, true); }
public List <RegionEntity> findAll() { //Lista de regiones List <RegionEntity> regiones = new List <RegionEntity>(); //Recorrer filas de la tabla Región //(RegionRow) foreach (MySiteDataSet.RegionRow row in adapter.GetData().Rows) { //Creando objeto RegionEntity por cada //Fila encontrada RegionEntity region = new RegionEntity(); region.Codigo = row.codigo; region.Nombre = row.nombre; //Agregando la región a la lista de regiones regiones.Add(region); } return(regiones); }
public void CopyRegions(IOdb odb, NorthwindDataSet dataSet) { //Processing Regions LogMessage("Reading Regions...", false); var adapter1 = new RegionTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { LogMessage("Regions: " + row.RegionID.ToString() + " ...", false); var r = new Region { RegionID = row.RegionID, RegionDescription = row.RegionDescription }; odb.Store(r); LogMessage("saved", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor <Region>().AddUniqueIndexOn("Region_RegionID_PK_index", Domain.Region.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances <Region>(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 Regions" + Environment.NewLine, true); }
public void CopyRegions() { //Processing Regions LogMessage("Reading Regions...", false); RegionTableAdapter adapter1 = new RegionTableAdapter(); NorthwindDb4o.NorthwindDataSet.RegionDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.RegionRow row in table1) { LogMessage("Regions: " + row.RegionID.ToString() + " ...", false); Region r = new Region(); r.RegionID = row.RegionID; r.RegionDescription = row.RegionDescription; container.Store(r); LogMessage("saved", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(Region)).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 Regions" + Environment.NewLine, true); }