New Posts New Posts RSS Feed: Link to SQL vs. Stored Procedures
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Link to SQL vs. Stored Procedures
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
BillG View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 05-Dec-2007
Location: Monroe, MI
Posts: 233 		Post Options Post Options   Quote BillG Quote  Post ReplyReply Direct Link To This Post Topic: Link to SQL vs. Stored Procedures
    Posted: 26-Jan-2014 at 12:10pm
up to this point in my upgrading a vb app, I have been using Objects to work from my data. Now i am coming across some vb code that relies heavily on SQL for iserrts, updates, and deletes. I am looking for some recommendations here. Should i continue using objects and look through collections for inserting, update, and deleting moderate amounts of data or should i use Link to SQL or even Stored Procedures? What advice could you give me here?

Bill
Back to Top
DenisK View Drop Down
IdeaBlade
IdeaBlade


Joined: 25-Aug-2010
Posts: 715 		Post Options Post Options   Quote DenisK Quote  Post ReplyReply Direct Link To This Post Posted: 28-Jan-2014 at 6:16pm
Hi Bill,

I would say that as a rule of thumb, if the entities you're inserting, updating or deleting are not required on the client, you can safely use Stored Procs.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down