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