Database Samples (Best Practices)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?R3JlZw==?=
    #1

    Database Samples (Best Practices)

    Are there any sample projects or web-sites out there that discuss best
    practices with regards to inserting, editing and deleting records in a
    database with VB.Net. I know how I can do all this, I am just looking to see
    some best practice solutions that are out there to get some better ideas on
    how I want to be approaching this.

    Most often it seems when I find something with regards to this topic, it's
    quite limited. I'd like to see some examples of how these utilities are
    implemented to give me some better ideas of how I want to approach this on
    project that will contain many, many tables, thus I want to use as much code
    re-use as possible.

    Thanks, Greg
    Tags: None
    • Spam Catcher
      #2
      Re: Database Samples (Best Practices)

      jialge@online.m icrosoft.com (Jialiang Ge [MSFT]) wrote in
      news:gnpNZXJbIH A.360@TK2MSFTNG HUB02.phx.gbl:
      (4) Subsonic (http://www.codeplex.com/subsonic) can automatically
      generate the data access layer of a project according to the database
      schema, so that programmers can focus on the business logic.
      I use LLBLGen Pro (http://www.llblgenpro.com) which is a similar prodct.
      Works very well.

      As for DB practices, you should use SQL parameters to avoid SQL injection
      attacks:

      http://msdn2.microsoft.com/en-us/library/ms998271.aspx

      Or for general security guidance:

      http://msdn2.microsoft.com/en-us/library/ms998408.aspx

      --
      spamhoneypot@ro gers.com (Do not e-mail)

        Comment

        Previous template Next
        Working...