public One2OneParentEntity CreateEntityWithChildB()
{
One2OneParentEntity entity = new One2OneParentEntity();
entity.Id = IdB;
entity.Name = "Parent B";
entity.ChildEntity = new One2OneChildEntityB();
entity.ChildEntity.Name = "Child B";
return(entity);
}
public One2OneParentEntity CreateEntityWithChildA()
{
One2OneParentEntity entity = new One2OneParentEntity();
entity.Id = IdA;
entity.Name = "Parent A";
entity.ChildEntity = new One2OneChildEntityA();
entity.ChildEntity.Name = "Child A";
return(entity);
}
public static void DoTest()
{
One2OneExample example = new One2OneExample();
ITransaction tx = ExampleBase.SetupDb();
example.Patch(tx);
One2OneParentEntity entityA = example.CreateEntityWithChildA();
example.Persist(tx, entityA);
One2OneParentEntity entityB = example.CreateEntityWithChildB();
example.Persist(tx, entityB);
entityA = example.Retrieve(tx, One2OneExample.IdA);
Console.WriteLine("Entity Name = " + entityA.Name);
Console.WriteLine("Entity Child Name = " + entityA.ChildEntity.Name);
entityB = example.Retrieve(tx, One2OneExample.IdB);
Console.WriteLine("Entity Name = " + entityB.Name);
Console.WriteLine("Entity Child Name = " + entityB.ChildEntity.Name);
entityA.Name = "Updated Entity A";
entityA.ChildEntity.Name = "Updated Child Entity A";
example.Persist(tx, entityA);
entityB.Name = "Updated Entity B";
entityB.ChildEntity.Name = "Updated Child Entity B";
example.Persist(tx, entityB);
entityA = example.Retrieve(tx, One2OneExample.IdA);
Console.WriteLine("Entity Name = " + entityA.Name);
Console.WriteLine("Entity Child Name = " + entityA.ChildEntity.Name);
entityB = example.Retrieve(tx, One2OneExample.IdB);
Console.WriteLine("Entity Name = " + entityB.Name);
Console.WriteLine("Entity Child Name = " + entityB.ChildEntity.Name);
entityA.Status = EntityStatus.Deleted;
example.Persist(tx, entityA);
entityB.Status = EntityStatus.Deleted;
example.Persist(tx, entityB);
entityA = example.Retrieve(tx, One2OneExample.IdA);
Console.WriteLine("Entity A = " + entityA);
entityB = example.Retrieve(tx, One2OneExample.IdB);
Console.WriteLine("Entity B = " + entityB);
ExampleBase.CloseDb();
}
public One2OneParentEntity Retrieve(ITransaction tx, int id)
{
IDbCommand cmd = tx.CreateCommand();
cmd.CommandText = "select * from parent_entity where id = ?";
IDbDataParameter parameter = cmd.CreateParameter();
cmd.Parameters.Add(parameter);
parameter.DbType = DbType.Int32;
parameter.Value = id;
One2OneParentEntity entity = null;
IDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
entity = new One2OneParentEntity();
entity.Retrieve(reader, tx);
}
DbMgtUtility.Close(reader);
DbMgtUtility.Close(cmd);
return(entity);
}
public void Persist(ITransaction tx, One2OneParentEntity entity)
{
entity.Persist(tx);
}
