public static void InitializeTests(TestContext tc) { _opt = new DbContextOptionsBuilder <DataContext>().UseInMemoryDatabase("VectorTests"); _node1 = new Node { NodeName = "France", NodeType = NodeValueTypes.Name, NodeTopic = NodeTopics.Country }; _node2 = new Node { NodeName = "3", NodeType = NodeValueTypes.Percentage, NodeTopic = NodeTopics.Economic }; _node3 = new Node { NodeName = "Belgium", NodeType = NodeValueTypes.Name, NodeTopic = NodeTopics.Political }; _node4 = new Node { NodeName = "GDP", NodeType = NodeValueTypes.Name, NodeTopic = NodeTopics.Economic }; _node5 = new Node { NodeName = "Employment", NodeType = NodeValueTypes.Name, NodeTopic = NodeTopics.Economic }; _node6 = new Node { NodeName = "Canada", NodeType = NodeValueTypes.Name, NodeTopic = NodeTopics.Country }; _reqParams = new DataRequestParams { PageNumber = 1, PageSize = 4 }; }
/// <summary> /// Retrieve all vectors from the database for a given node. /// <summary> /// <param name="nodeId">The ID of the embedded Subject Node.</param> /// <returns>The found vector object collection</returns> public async Task <IEnumerable <Vector> > SelectVectorsByNodeAsync( int nodeId, DataRequestParams reqParams) { var vectorSet = await( from vc in _ctx.Vectors where vc.VectorStatus == VectorStatusValues.Active where vc.NodeSubject == nodeId orderby vc.VectorId select vc ) .Skip(reqParams.PageSize * (reqParams.PageNumber - 1)) .Take(reqParams.PageSize) .ToListAsync(); if (vectorSet.Count() > 0) { return(vectorSet); } else { return(null); } }