views:

955

answers:

7

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.
+1  A: 

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/

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.
Joshua Hudson
+1  A: 

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

Michael Kniskern
+8  A: 

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.

George Stocker
+1  A: 

Writing this from my iPhone so sorry for the brvity.

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

NotMyself
hows that keyboard treating you? ;p
Shawn Simon
+3  A: 

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.

domus.vita
A: 

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.

Raghavendra
Hi, welcome to Stack Overflow!I know that asking new and unrelated questions in a thread is sometimes the norm out there on the 'net... but this site is all about asking questions. I strongly encourage you to ask your question in its own question post. There's no harm in doing so, and the likelihood of someone seeing it to answer it is exponentially increased. Also, I encourage you not to ask people to send you the answer privately: we all benefit as a community from public answers.
EdgarVerona
@Raghavendra: Please take @Edgar's advice. This page is 18 months old, so very few people are likely to even see this. Besides that, the site works by putting new questions on the front page for everyone to see. Use the **[Ask Question]** button at the top right of the page.
Bill the Lizard
A: 

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