Esecuzione di una store procedure su PostgreSQL 8.4

C#Copia

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Odbc;

namespace SgartApplicationTest
{
  class Program
  {
    static void Main(string[] args)
    {
      System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo(1033);

      string cnnStr = "Dsn=***OdbcDsnName***;";
      using (OdbcConnection cnn = new OdbcConnection(cnnStr))
      {
        cnn.Open();
        using (OdbcCommand cmd = cnn.CreateCommand())
        {
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = string.Format(
            "select readings_update('{0}','{1}');"
            , DateTime.Now.ToString("yyyy-MM-dd HH:mm", ci)
            , (12782.256).ToString(ci));
          cmd.ExecuteNonQuery();

        }
      }
    }
  }
}