.NET Graph Client CRUD Help Thanks!

[dellams]

Hi Guys,

I posted this in the Cypher category but wasn't sure if it was better to post here because it is using the .NET Graph Client?

.NET Graph Client CRUD Help Cypher

Hi Tribe, I am trying to get this Cypher query to work in the .net GraphClient but I am getting back the error: "Input string was not in a correct format" Avatar avatar = GraphClient.Cypher.Match("(p:Avatar {Username: {nameParam}})") //TODO: Need to add password to match query... .WithParam("nameParam", username) .Return(p => p.As()) .ResultsAsync.Result.Single(); Any ideas? 🙂 I also have this for the Save method for creating or updating, it runs the create code with no errors but not…

Should I re-post it here or is the link above ok?

Any help would be really appreciated thanks.

Cheers
D.

[dellams]

Anyone?

[florent_biville]

Have you tried replacing {nameParam} with $nameParam? The latter is the parameter syntax for neo4j 4+.

[mdfrenchman]

Sorry for the late response. With the old parm inclusion syntax you've got two issues.

1. Need to have the $ at the beginning of the string for interpolation.
2. to interpolate strings you need to escape the existing {} that you want sent as part of the cypher.

So you'd want this:

GraphClient.Cypher.Match($"(p:Avatar {{Username: {nameParam}}})")

OR if you want to use the recommended neo4j params, which I suspect you're doing with the WithParam

Use $nameParam

GraphClient.Cypher.Match("(p:Avatar {Username: $nameParam})").WithParam("nameParam", username)

Hope that helps!