OracleConnection not returning correct number of rows

[BiffMaGriff]

I have an query I run against an Oracle Connection.
I have these objects, an event table and a table to map my objects to my events.
My select statement selects the most recent event for each object and if it meets certain requirements then the object's id is returned.

something like

select o.id from
objects o, events e, objecteventmap oem,
(select max(date), o.id from events e, objects o, objecteventmap oem 
where e.id = oem.eventid and o.id = oem.objectid) ss
where
o.id = oem.objectid and
e.id = oem.eventid and
o.id = ss.id and
e.date = ss.date and
<more where clause stuff>
 

The problem is when I run the query in Oracle SQL Developer I get 42 rows (the correct result set) and when I create an OracleCommand object and put that in as my query in my C# I get 30 rows (a reduced result set).

Help!

Edit:
Ok so I broke apart my query to get a better look at the data. In .net for some reason my Max date is getting the wrong date for some events. I am getting the ides of march instead of the correct date for a bunch of them. The weird thing is I do not have March 15th entered in my data anywhere....

[Plater]

Have you checked to see if more then one table is being returned?
Edit: Oh it was date trouble. Are you making sure your date formats come out correctly?

[BiffMaGriff]

I had a look into the ungrouped data. In SQL Developer I'm getting 193 rows in .Net I'm getting 239 rows :(
Could this be a driver issue? It is like my join is all messed up.

[BiffMaGriff]

Ok, the select * on my mapping table gives different row counts .Net than when in SQl Developer.

Could this be a garbage collection issue?

[Plater]

Have you tried making the SQL code into stored procedure? (Oracle has those right? I never got to in-depth with oracle)

[BiffMaGriff]

Ok, I think perhaps it might be a commit type issue.

[BiffMaGriff]

My co-worker says it is a pain in the butt to get a result set returned from an oracle sp.

[BiffMaGriff]

Ok I think I solved it... it just took 2 days...
I don't think my deletes were being committed to the DB. At some point I started getting the correct rows in .Net. I think this happened because I was not putting my OracleCommand object within a transaction... I hope.
Anyways to prevent this use this from happening again I am doing this.

        OracleCommand com = GetCommand(myCommand);
            com.Connection.Open();
            OracleTransaction ot = com.Connection.BeginTransaction();
            com.Transaction = ot;
            try
            {
                com.Prepare();
                com.ExecuteNonQuery();
                com.Transaction.Commit();
            }
            catch
            {
            }
            finally
            {
                com.Connection.Close();
            }