could not determine data type of parameter $1

[alfrye]

I am using dotconnect for postgresql and I am trying to use LINQ to call the the Postgresql funciton pg_column_size to determine the size my string is going to take up on the database.

Here is a sampel of the code I am using

Code: Select all

    IEnumerable mysize = context.ExecuteQuery("select pg_column_size({0});","test");
              foreach (var item in mysize)
                  {
                  contentSize = item;
                  }
             
              }

  

[AndreyR]

Thank you for the report, I have reproduced the error.
I will let you know about the results of our investigation as soon as possible.

[AndreyR]

Unfortunately, we are unable to perform such a call in LINQ to PostgreSQL.
Please note that this code cannot be called using teh following ADO.NET sample code as well:

Code: Select all

    PgSqlConnection conn = new PgSqlConnection("uid=*;pwd=*;host=andreyr;database=testdb");
      conn.Open();
      PgSqlCommand cmd = new PgSqlCommand("select pg_column_size(:p0);", conn);
      cmd.Parameters.Add("p0", "test");
      using (PgSqlDataReader rdr = cmd.ExecuteReader()) {
        while (rdr.Read()) {
          int i = rdr.GetInt32(0);
        }

The problem is associated with the fact that the type of parameter in this case is "any" in PostgreSQL, and cannot be determined correctly.