C# SQL Server - Appraisal system - best design

Question

0.00/5 (No votes)

See more:

, +

I'm designing and developing an appraisal system using C#4.0, SQL Server 2008 and ASP.NET I'm a novice with around 1 years experience of these tools.

I want to be able to create multiple objectives for an employee and store them in a SQL Server 2008 db. I want to create objectives dynamically so I only use 1 ASP page to enter/save/display information, but pull in the objectives depending on the navigation (there is no fixed limit on the number of objectives an employee may have).

For example, I click a Create Objective button, the page displays the correct new objective number, I can then fill in the fields on the form and save it, create a new one, move ot the next or previous one, delete an objective etc.

Please can you advise the best way to design this application from the database perspective?

Posted 1-Mar-12 22:47pm

stevetdunn

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pietvredeveld · Accepted Answer · 2012-03-02T09:42:00

Solution 1

Hi,

Now days you should not care about the database scheme that much, because with the ASP.Net entity-framework[^] can take care about the best way to design the database. It uses a uses a code first approach, the entity-framework does all the plumbing for you ;-)

Regards
Piet