Database layer:
The database layer contains the tables, views and stored procedures which deals with the database. Usually this layer is created before making the other layers. Database layer is also the most important layer in the application architecture that's why most of the time is spent making the database layer solid so, the pillars of the application are strong and scalable.
2) Business logic layer:
Business logic layer contains the logic of the application. Like the database layer this layer is not exposed to the users directly but a user interface is provided to do so.
3) Presentation layer:
The presentation layer is what the user actually sees. The html pages with some animation, the textboxes to take input and message boxes to alarm the user of the operation of his action. Presentation layer must be developed in such a way that it can be changed without doing any changes to the business or the database layer. This means that the presentation layer must be independent of the database and the business layers. Also the presentation layer should be made in such a way that changing the presentation to the user will take less time and effort.
Tips about the database layer:
1) Database layer as I pointed out earlier consists of a database, stored procedures and tables etc. Its always good to use stored procedures instead of Ad-Hoc queries. Ad-Hoc queries have the danger of SQL Injection Stored procedures on the other hand are more fast to execute and gives the performance boost. Since those procedures used often are executed from the cache.
2) It's very important that you normalize the database design. You should carefully map out the one-one, one-many, many-many relationships. If normalization of the database is not handled carefully at the right time it can destroy the whole application and you may have to start from scratch.
Tips about the Business layer:
Business layer is where all the cool stuff happens. Usually for each subject (noun) in our specification we make a class for it. Suppose we are making an application where users and sends emails and receive messages depending on if their email is sent or not.
Some users tends to keep all the business logic in the presentation layer. This approach is very dangerous since user has a direct interaction with the business logic and it becomes easily hackable. That's why business logic is always kept in the class libraries this approach makes the separation of the user interaction with business logic and also makes the libraries portable so, it can be used by some other same type of application.
Sometimes its also a good idea to map the class fields to the database column names. Suppose our application stored articles so, our mapping class will look something like this:
public class ArticleDetails
{
public string Title;
public string Url;
public string Description;
}
Data Access Application Block:
I also explicitly use Microsoft.NET Data Access Application Block. Application Blocks makes the code simpler to understand and modify. Another good reason to use the application block is that it makes the code more readable if many coders are using the same block instead you find yourself reading every line of code written by the developer and trying to understand his coding style of accessing the database.
Messages Class:
Sometimes you want to print a message "Data has been successfully entered" if the transaction was successful and "Data not entered" when, the transaction was a failure.
Most of the developers perform this task by simply adding the if-else block in the presentation layer.
bool isDataInserted = code.AddCodeSample(txtTitle,txtDescription);
if(isDataInserted)
{
// Data inserted successfully
}
else
{
// Data not inserted
}
its a good idea to make a class whose main purpose is to return messages. You can call this class DBMessages.
| // message returned after the insert operation public static string InsertMessages(bool isAdded)
} // message returned after the Update Operation public static string UpdateMessages(bool isUpdated)
} |
As you see now you only have to write a single line of code to get the message. Here lblMessage is a label control.
lblMessage.Text = DBMessages.InsertMessages(isAdded);
Using this approach you can also modify your message in one place and it will be changed everywhere.
Tips for the Presentation Layer:
Presentation layer design should always be consistent since this layer will be the one that will change often. Consistent design can come in the form of the Cascading Style Sheets and User Controls. By using Cascading Style Sheets your page has a consistent look and feel. A simple change in the Cascading Style Sheet will bring changes to all the pages without even touching them.
User controls is another way for making sections that are easily changed. If on the other hand if they are not marked as a user controls we will have to go to each page and manually change it which, is a pain.
