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]

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/HeadFirst/HeadFirstDesignPatterns/HeadFirstPatternsIndex.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

 

[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]

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.

 

[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.