Database Samples (Best Practices)

[=?Utf-8?B?R3JlZw==?=]

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

[Spam Catcher]

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)