Design patterns in .NET

[Coder-X]

Hi,

i have a few questions i would like to ask :

1 - Where can i find good design patterns resources for .NET ?
2 - What's the best design pattern for a windows database application (
multiuser ) ?
3 - I'm trying to develop a simple database application . I'm thinking of
defining a class for every table in the database. Is this a good design
practice ?

Thanks,
José Carlos Ferreira

[W.G. Ryan MVP]

"Coder-X" <en***************@yahoo.com.br> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi,

i have a few questions i would like to ask :

1 - Where can i find good design patterns resources for .NET ? http://www.wickedlysmart.com/HeadFir...ernsIndex.html
You should also check out the Microsoft Patterns and Practices site
http://msdn.microsoft.com/practices/ 2 - What's the best design pattern for a windows database application (
multiuser ) ? There are many many patterns each of which handles different areas. And
best is really dependent on what you are trying to accomplish. There is no
1 best pattern for everythign in windows forms, you'll probably want to use
multiple patterns. 3 - I'm trying to develop a simple database application . I'm thinking of
defining a class for every table in the database. Is this a good design
practice ? Probably not. Every time you have a new table , you'll have to recompile
your application. You may want to take a look at some of the OR Mappers, two
of the best I know of are www.deklarit.com and llblGenPro
http://www.llblgen.com/defaultgeneric.aspx
Thanks,
José Carlos Ferreira

[Chris Dunaway]

I second the motion on the "Head First" book. While the code is in
Java, it does not really matter, the patterns are explained very well.

[Brian Gideon]

Coder-X wrote:

Hi,

i have a few questions i would like to ask :

1 - Where can i find good design patterns resources for .NET ?
"Patterns of Enterprise Application Architecture" by Martin Fowler
(ISBN 0-321-12742-0) may be just the resource you're looking for. The
author explains several patterns for working with relational databases.
2 - What's the best design pattern for a windows database application (
multiuser ) ?
There isn't a single best pattern for every problem. Hopefully, that's
a question you'll be able to answer after you have reviewed patterns
others have used in the past.
3 - I'm trying to develop a simple database application . I'm thinking of
defining a class for every table in the database. Is this a good design
practice ?
You did say it would be a simple application, so yes, it might be a
good design in your case.
Thanks,
José Carlos Ferreira

[W.G. Ryan MVP]

Thanks Chris, and the C# code is included on that link which makes it even
cooler. Pretty close to Java but there are definitely enough nuances to
make you apprecaite the conversion.
"Chris Dunaway" <du******@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

I second the motion on the "Head First" book. While the code is in
Java, it does not really matter, the patterns are explained very well.

[SP]

"Coder-X" <en***************@yahoo.com.br> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi,

i have a few questions i would like to ask :

1 - Where can i find good design patterns resources for .NET ?
2 - What's the best design pattern for a windows database application (
multiuser ) ?
3 - I'm trying to develop a simple database application . I'm thinking of
defining a class for every table in the database. Is this a good design
practice ?
You should be asking the question more like "how will I persist my
classes?". At one end of the spectrum is mapping each class to a table. At
the other end is mapping every class to use just one table. You will
probably want to do in between these two options.

Take a look at Agile Database Techniques by Scott Ambler.

SP

Thanks,
José Carlos Ferreira