#
Migrating from Cypher to Curiosity
If you are familiar with Cypher (the query language used by Neo4j and others), this guide will help you translate your knowledge to Curiosity's C# IQuery fluent interface.
While Cypher is a declarative text-based language, IQuery is a programmatic builder. However, the conceptual steps (Start -> Filter -> Traverse -> Return) are very similar.
#
Basic Lookups
#
1. Get all nodes of a label
Cypher
MATCH (n:Person) RETURN nCuriosity
Query().StartAt("Person").Emit()
#
2. Get a node by ID
Cypher
MATCH (n) WHERE id(n) = '123' RETURN nCuriosity
Query().StartAt("Person", "123").Emit()
#
3. Get a node by Key/Property
Cypher
MATCH (n:Person {email: 'alice@example.com'}) RETURN nCuriosity
Query().StartAt("Person", "email", "alice@example.com").Emit()
// OR
Query().StartAt("Person").WhereString("email", "alice@example.com").Emit()
#
Filtering
#
4. Filter by string property
Cypher
MATCH (n:Person) WHERE n.status = 'Active' RETURN nCuriosity
Query().StartAt("Person").WhereString("status", "Active").Emit()
#
5. Filter by numeric property
Cypher
MATCH (n:Product) WHERE n.price > 100 RETURN nCuriosity
Query().StartAt("Product").Where(n => n.GetFloat("price") > 100).Emit()
#
6. Filter by boolean
Cypher
MATCH (n:Task) WHERE n.completed = true RETURN nCuriosity
Query().StartAt("Task").Where(n => n.GetBool("completed")).Emit()
#
7. Filter NOT equal
Cypher
MATCH (n:Person) WHERE n.status <> 'Deleted' RETURN nCuriosity
Query().StartAt("Person").WhereNotString("status", "Deleted").Emit()
#
8. Filter IN list
Cypher
MATCH (n:Person) WHERE n.role IN ['Admin', 'Manager'] RETURN nCuriosity
Query().StartAt("Person").WhereString("role", new[]{"Admin", "Manager"}).Emit()
#
9. Filter by Timestamp
Cypher
MATCH (n:Log) WHERE n.timestamp >= datetime('2023-01-01') RETURN nCuriosity
Query().StartAt("Log").WhereTimestamp(from: new Time(2023, 1, 1), to: Time.MaxValue, insideBoundary: true).Emit()
#
Relationships
#
10. Simple Traversal
Cypher
MATCH (p:Person)-[:KNOWS]->(f:Person) RETURN fCuriosity
Query().StartAt("Person").Out("Person", "KNOWS").Emit()
#
11. Traversal ignoring edge type
Cypher
MATCH (p:Person)-->(d:Department) RETURN dCuriosity
Query().StartAt("Person").Out("Department").Emit()
#
12. Traversal ignoring target label
Cypher
MATCH (p:Person)-[:HAS_FILE]->(f) RETURN fCuriosity
Query().StartAt("Person").Out(edgeType: "HAS_FILE").Emit()
#
13. Multi-hop Traversal
Cypher
MATCH (p:Person)-[:KNOWS*2]->(fof:Person) RETURN fofCuriosity
Query().StartAt("Person").OutMany(levels: 2, nodeTypes: new[] { "Person" }, edgeTypes: new[] { "KNOWS" }).Emit()
#
14. Check if related to specific node
Cypher
MATCH (p:Person) WHERE (p)-[:WORKS_FOR]->(:Company {id: 'C1'}) RETURN pCuriosity
Query().StartAt("Person").IsRelatedToVia(Node.GetUID("Company", "C1"), "WORKS_FOR").Emit()
#
15. Check if NOT related
Cypher
MATCH (p:Person) WHERE NOT (p)-[:HAS_Badge]->() RETURN pCuriosity
Query().StartAt("Person").IsNotRelatedToVia(edgeType: "HAS_Badge").Emit()
#
Advanced Logic
#
16. Union
Cypher
MATCH (n:Manager) RETURN n
UNION
MATCH (n:Director) RETURN nCuriosity
var q1 = Query().StartAt("Manager");
var q2 = Query().StartAt("Director");
q1.Union(q2).Emit();
#
17. Intersection
Cypher
MATCH (n:Person) WHERE n.age > 30 AND n.status = 'Active' RETURN n
// (Implicit intersection of filters)Curiosity
// Fluent chaining acts as intersection
Query().StartAt("Person").Where(n => n.GetInt("age") > 30).WhereString("status", "Active").Emit()
// Or explicit set intersection
var q1 = Query().StartAt("Person").Where(n => n.GetInt("age") > 30);
var q2 = Query().StartAt("Person").WhereString("status", "Active");
q1.Intersect(q2).Emit();
#
18. Sorting and Limiting
Cypher
MATCH (n:Product) RETURN n ORDER BY n.created DESC LIMIT 10Curiosity
Query().StartAt("Product").SortByTimestamp(oldestFirst: false).Take(10).Emit()
#
19. Counting
Cypher
MATCH (n:Person) RETURN count(n)Curiosity
int count = Query().StartAt("Person").Count();
#
20. Distinct
Cypher
MATCH (a)-[:FRIEND]->(b) RETURN DISTINCT bCuriosity
Query().StartAt("Person").Out("Person", "FRIEND").Distinct().Emit()
#
21. Path Finding (Shortest Path)
Cypher
MATCH p=shortestPath((a:Person {id:'A'})-[*]-(b:Person {id:'B'})) RETURN pCuriosity
Query().PathBetween(Node.GetUID("Person", "A"), Node.GetUID("Person", "B"))
#
22. Text Search
Cypher
MATCH (d:Document) WHERE d.content CONTAINS 'project' RETURN dCuriosity
Query().StartSearch("Document", "content", Search.Parse("project")).Emit()