Where can I find a Good Sample ASP.NET Database Driven Web Application?

Question

I would like to learn the best practices to employ when creating a database driven web-application. I prefer to learn from examples. What is a good sample application that I can download and run to learn this:

I am looking for:

1. Should be written in C# (preferably)
2. Should contain a complex database design (parent child relations, etc.)
3. Should implement the best practices for an ASP.net website as well as for database design.
4. Preferably uses Oracle.

Solution 1

If you don't want to worry about writing your DAL (Data Access Layer), then I suggest looking at Nhibernate. There are samples with it and ASP.NET here, here, and here. Here's a sample with just Oracle and ASP.NET.

If you are looking for just sample ASP.NET Applications without an Object Relational Mapper like NHibernate, try this.

Also, on a higher level, you're looking for an N-Tier ASP.NET application design. There are good tutorials on that here, here, and here.

Solution 2

There are lots of examples in ASP.NET Starter Kits. I really like the BlogEngine.NET application. For higher-end basics (hmmm..."higher-end basics"...oxymoron?) the BeerHouse E-Commerce application is great.

Solution 3

For Oracle, look for samples using the System.Data.OracleClient.

Solution 4

Writing this from my iPhone so sorry for the brvity.

Check out rob conrey's MVC storefront videos & source.

Solution 5

For 1 through 3, I would recommend downloading some of the ASP.NET starter kits. I'm not sure if they work with Oracle though.

Some of the bigger frameworks are also great starts like DotNetNuke. They make great use of best practices.

http://www.asp.net/community/projects/

View more solutions

Comments

[Joshua Hudson]

I looked into DotNetNuke for you and oracle and while I don't see any free oracle db providers there are some for pay ones out there. So I still say my answer is good for requirements 1 - 3.

[Shawn]

hows that keyboard treating you? ;p