SQL Data Access

Discussion in 'ASP .Net' started by Kenneth Keeley, May 24, 2004.

  1. Hi,
    Is it safer to use an SQL Stored Procedure or to create the querry in
    asp.net code? Which would run faster? and what is the best way to protect my
    SQL server from hackers.

    Thanks for any help.
    Kenneth Keeley
    Kenneth Keeley, May 24, 2004
    #1
    1. Advertising

  2. Kenneth,

    Use Stored Procedure's with the command objects in ADO.Net. You can give the sql user no rights except to execute those SP's. Running raw SQL is always a risk and runs slower cause SQL doesn't have a pre-built query plan.

    -Calvin Luttrell
    ProjectThunder.com

    > Is it safer to use an SQL Stored Procedure or to create the querry in
    > asp.net code? Which would run faster? and what is the best way to protect my
    > SQL server from hackers.
    Calvin Luttrell/ProjectThunder.com, May 24, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Harry Zoroc
    Replies:
    1
    Views:
    933
    Gregory Vaughan
    Jul 12, 2004
  2. ecoolone
    Replies:
    0
    Views:
    755
    ecoolone
    Jan 3, 2008
  3. Savvoulidis Iordanis

    XML data access or DB data access ?

    Savvoulidis Iordanis, Jan 7, 2009, in forum: ASP .Net
    Replies:
    2
    Views:
    411
    Savvoulidis Iordanis
    Jan 7, 2009
  4. cooldv
    Replies:
    3
    Views:
    271
    WIlliam Morris
    Oct 6, 2003
  5. Replies:
    10
    Views:
    274
    Bob Barrows [MVP]
    Jan 6, 2005
Loading...

Share This Page