public void PrepareParametersForSchemaFetching(IDbCommand cmd)
{
// no notion of declaring parameters in Postgres
foreach (var queryParam in FindUndeclaredParameters(cmd.CommandText))
{
var myParam = new global::Npgsql.NpgsqlParameter();
myParam.ParameterName = queryParam.DbName;
if (!string.IsNullOrEmpty(queryParam.DbType))
{
myParam.DbType = (DbType)System.Enum.Parse(typeof(DbType), queryParam.DbType);
}
myParam.Value = DBNull.Value;
cmd.Parameters.Add(myParam);
}
}
public void PrepareParametersForSchemaFetching(IDbCommand cmd)
{
// no notion of declaring parameters in Postgres
// refacto, will this work harvesting connection string from passed command !
foreach (var queryParam in FindUndeclaredParameters(cmd.CommandText, cmd.Connection.ConnectionString))
{
var myParam = new global::Npgsql.NpgsqlParameter();
myParam.ParameterName = queryParam.DbName;
if (!string.IsNullOrEmpty(queryParam.DbType))
{
myParam.DbType = (DbType)System.Enum.Parse(typeof(DbType), queryParam.DbType);
}
myParam.Value = DBNull.Value;
cmd.Parameters.Add(myParam);
}
}
