Binary expression in return statement neo4jClient neo4j

Question

I am trying to get the following Cypher query written out in GraphClient:

START agency=node(12345)
MATCH agency
        -[:AGENCY_HAS_PEOPLE]-()
        -[:AGENCY_HAS_PERSON]-person
        ,person-[?:PERSON_IS_CARER]-carer
        ,person-[?:PERSON_IS_CLIENT]-client
WHERE (person.UniqueId! = 18989)   
RETURN person, carer is not null as IsCarer, client is not null as IsClient

The query works fine in the console and returns the results I expect:

person           IsCarer    IsClient
Node(1545421)    True       False

When I try to write that query using Neo4jClient, it throws the following exception.

Expression of type System.Linq.Expressions.LogicalBinaryExpression is not supported.

It is mainly due to the expression in the return statement:

.Start(...)
.Match(...)
.Where(...)
.Return((person, client, carer) => new
{
    Person = person.As<Person>(),
    IsClient = client != null
    IsCarer = carer != null
});

Is anyone already working on a solution for this? Is there a workaround for it? Is there any other way to write this query to get the same result? If I were to implement a solution for this, is there anything related to the internals of Neo4jClient (limitation, pitfalls) that I should know before I begin?

Thanks..

Tatham Oddie Tatham Oddie · Accepted Answer · 2013-12-20T00:26:31

It's a bug in https://github.com/Readify/Neo4jClient/blob/master/Neo4jClient/Cypher/CypherReturnExpressionBuilder.cs

Fork the project
Clone it locally
Write a failing test that demonstrates the problem, in https://github.com/Readify/Neo4jClient/blob/master/Test/Cypher/CypherFluentQueryReturnTests.cs
Fix the issue
Commit and push your fix
Open a pull request

When I'm happy with the quality of the solution, I'll accept and merge the pull request. The fix will then be published to NuGet within a few minutes.

Binary expression in return statement neo4jClient neo4j

1 Answers