Question 90713 in PostgreSQL Question posted in
The official documentation can be found here.

How to send encrypted byte array data in bytea column via C# Npgsql query – Postgresql

What I want is to send encypted data from my app to PostgreSQL database via formatted string (query) by using Npgsql. Problem is that after sha256.ComputeHash() I get byte array which I’m trying to send by inserting it into my string query. It works fine but then in my dbms column I see System.Byte[] instead of byte array. How can I fix that?

My string query is something like that:

private readonly SHA256 sha256 = SHA256.Create();
string sql = $"""
                    INSERT INT table(encrypted_column) VALUES (
                                                            '{sha256.ComputeHash(data)}'); 
                    """;
```[What in db after Query][1]


  [1]: https://i.stack.imgur.com/9Ch7t.png
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    So using a formatted string was a bad idea. Thanks to SNBS better way is to use parameters: https://www.npgsql.org/doc/basic-usage.html


  2. 0

    SHA256.ComputeHash() returns a byte array. It is converted to a string implicitly, using ToString(). And it just returns the type string for byte array. You should use this query:

    string sql = $"""INSERT INTO table (encrypted_column) VALUES ('{Encoding.UTF8.GetString(sha256.ComputeHash(data))}');""";
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search