Devart Forums

Posted: **Wed 23 Jun 2010 20:19**

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;
                  }
             
              }

Posted: **Mon 05 Jul 2010 10:55**

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.

Posted: **Wed 21 Jul 2010 12:12**

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.

Devart Forums

could not determine data type of parameter $1

could not determine data type of parameter $1