Thread: Problem with functions

public void DeleteRow()

{

try

{

int result;

result = 0;

NpgsqlCommand command = new NpgsqlCommand("sp_article_delete(@ArticleId)");

command.CommandType = CommandType.StoredProcedure;

command.Connection = npgsqlConnection;

command.Parameters.Add(new NpgsqlParameter("@ArticleId",DbType.String));

command.Parameters["@ArticleId"].Value = "1";

npgsqlConnection.Open();

result = command.ExecuteNonQuery();

Console.WriteLine("Result of delete: " + result.ToString());

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

finally

{

if (npgsqlConnection.State == ConnectionState.Open)

{

npgsqlConnection.Close();

}

}

}

3. Everything works fine but I can't get the number of records affected from the stored procedure.

4. If I do the following code this problem doesn't happen:

public void DeleteRow()

{

try

{

int result;

result = 0;

NpgsqlCommand command = new NpgsqlCommand("DELETE FROM \"Article\" WHERE articleid='1'");

command.CommandType = CommandType.StoredProcedure;

command.Connection = npgsqlConnection;

command.Parameters.Add(new NpgsqlParameter("@ArticleId",DbType.String));

command.Parameters["@ArticleId"].Value = "1";

npgsqlConnection.Open();

result = command.ExecuteNonQuery();

//return result;

Console.WriteLine("Result of delete: " + result.ToString());

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

finally

{

if (npgsqlConnection.State == ConnectionState.Open)

{

npgsqlConnection.Close();

}

}

}

How can I get the number of records affected by an insert/update/delete command when I use functions within the PostgreSql database. Or should I use the coding in 4. to reach the goal? Am I right when I think that the performance is better when using functions from within the PostgreSql database?

Greetings,

Jürgen