ClearParameters();
                    AddParms("@selectdate", reportdate, "SQL");
                    AddParms("@bankfedid", bankfedid, "SQL");
                   
string commandtext = @"
					 select COALESCE( m.storename, ' ') as storename, COALESCE(m.serialnumber, ' ') AS serialnumber, dbo.GetNextPickupdate(@selectdate,store) AS nextpickupdate, t.*, t.hundreds + t.fiftys + t.twentys + t.tens + t.fives + t.twos + t.ones + t.mixedcoin AS totaldeposit from smartsafetrans t 
					 LEFT JOIN view_ExpandedSafemast m ON t.safeid = m.idcol
                     where t.bankfedid = @bankfedid AND t.eventcode = 'DECL' AND t.postingdate <= @selectdate  and (t.verifyid = 0  OR 
                     (verifyid <> 0 AND  verifyid IN  (SELECT idcol FROM smartsafetrans WHERE bankfedid = @bankfedid AND eventcode =  'VER' AND postingdate > @selectdate )))";

When I run the above in a C# program as command type Text, it runs over a minute
The same query runs less than a second in the SSMS query window.
When I put the query in a stored procedure and called command type stored procedure it ran less than a second from C#.
I've never seen anything like this before.
Any ideas why this is happening?