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.

Answer 1

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/

Answer 2

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

Answer 3

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.

Answer 4

Writing this from my iPhone so sorry for the brvity.

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

Answer 5

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.

Answer 6

Hey Hi This Raghav I'm new to ASP.net. . i've a problem where I'm trying to update a marks table in which every time the student register number and the marks has to updated into a table when i press ENTERKEY after entering the marks. This project I'm trying it in asp.net with C sharp.

Answer 7

In my opinion best practice would dictate the following:

1. Use an ORM for your data access layer. This should ideally be in a a separate project so it can be changed if need be.
2. Should use MVC. If you use WebForms then you will surely find that your business logic and the display logic gets mixed together.
3. Learn database design separate and apart from learning to write code.
4. Keep reviewing object oriented design fundamentals.
5. Take time to learn design patterns. Not to become a slave to "The Gang of Four" but so that you can take advantage of proven patterns to solve common problems.