Executing an age Query using Npgsql and returning results in .NET application?

Question

I'm working on a.NET 7.0 application that needs to query a PostgreSQL database using Apache Age. To connect to the database, I'm using the Npgsql package.

I've successfully connected to the database with Npgsql, but I'm not sure how to run an Age query and receive the results. I've gone over the documentation for both Npgsql and Apache Age, but I'm still unsure how to go ahead.

I have tried this

using Npgsql;

var connString = "Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase"; using var conn = new NpgsqlConnection(connString); conn.Open();

var cmd = new NpgsqlCommand("MATCH (n)-[:LIKES]->(m) RETURN n.name, m.name", conn); var reader = cmd.ExecuteReader();

// What do I do next with the reader?

user21595662 · Accepted Answer · 2023-04-08 12:00:52Z

0

You can use this to retrieve th rows:

while (reader.Read()){
string name1 = reader.GetValue(0).ToString();
string name2 = reader.GetValue(1).ToString();
Console.WriteLine("{0} likes {1}", name1, name2);}

answered Apr 8, 2023 at 12:00

user21595662

Sign up to request clarification or add additional context in comments.

Comments

umerFreak · Accepted Answer · 2023-05-27 07:24:30Z

0

I don't think so that there is any driver for .net framework in apache age so it is not possible to run age queries in your application. As per apache age github we can see in drivers folder that there are drivers for nodejs, python, golang but none for .net (c#).

answered May 27, 2023 at 7:24

umerFreak

14 bronze badges

Collectives™ on Stack Overflow

Executing an age Query using Npgsql and returning results in .NET application?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related