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