ExecuteNonquery returns 0
<p>In my c# application i am trying to delete a record and i am returning result of the executenonquery to check the deletion is exactly happening as below.</p>

<pre><code>rowsAffected = db.ExecuteNonQuerySQL(
    @"DELETE FROM relation WHERE parent_itemid = " + SourceThingId + " AND " +
    "     child_itemid = " + ThingId + " AND " +
    "     relation_typeid = " + RelationTypeId);
</code></pre>

<p>And the executenonquery is definesd as below,</p>

<pre><code>using (SQLiteTransaction dbtrans = conn.BeginTransaction())
{
    SQLiteCommand cmd = conn.CreateCommand();
    cmd.CommandText = sqlExpr;
    cmd.CommandType = CommandType.Text;
    ireturn = cmd.ExecuteNonQuery();
    dbtrans.Commit();
}
return ireturn;
</code></pre>

<p>But when i am executing its not deleting and the value returns 0.The databse used is sqlite.</p>

<p>Do any one have idea why it happens.Please help.</p>

<p>Thanx in advance.</p>
