public void Model_RegisterChildModel()
{
var model = new RecursiveModel();
Assert.IsFalse(model.IsInitialized);
Assert.IsNull(model.ChildModel);
model.EnsureInitialized(false);
Assert.IsTrue(model.IsInitialized);
var childModel = model.ChildModel;
// assert ParentModelColumnMappings
Assert.AreEqual(model, childModel.GetParent());
Assert.AreEqual(1, childModel.ParentRelationship.Count);
Assert.AreEqual(childModel.ParentId, ((DbColumnExpression)childModel.ParentRelationship[0].SourceExpression).Column);
Assert.AreEqual(model.Id, childModel.ParentRelationship[0].Target);
// assert ChildColumns
model.ChildModels.Verify(childModel);
}
public List <RecursiveModel> recursive()
{
RecursiveModel recursiveModel;
List <RecursiveModel> recursiveModels = new List <RecursiveModel>();
connection.Connect();
SqlCommand sqlCommand = new SqlCommand("select c.name as 'name', c2.name as 'recurname' from corporation c inner join corporation c2 on c.corporation_id = c2.id", connection.getConnection());
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
recursiveModel = new RecursiveModel();
recursiveModel.name = reader["name"].ToString();
recursiveModel.recurname = reader["recurname"].ToString();
recursiveModels.Add(recursiveModel);
}
}
connection.disConnect();
return(recursiveModels);
}
