Print Page | Close Window

Link to SQL vs. Stored Procedures

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=4642
Printed Date: 28-Apr-2024 at 4:45am


Topic: Link to SQL vs. Stored Procedures
Posted By: BillG
Subject: Link to SQL vs. Stored Procedures
Date 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


Replies:
Posted By: DenisK
Date 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.


Print Page | Close Window