MESSAGE INBOX APP CODE
SQL statements from code as this approach is error prone and makes the application vulnerable to SQL Injection attacks. If I can't achieve something using Stored Procedures, I use parameterized commands. I always prefer having Stored Procedures. I tried to put most of the database interactions as Stored Procedures. The Data Layer mainly contains the database schema and the Stored Procedures to use the database. To visualize my application architecture: So that changing a layer will have minimal or no impact on other layers. All these layers are in separate solutions And finally on top of the BLL, my presentation layer is developed using ASP.NET web forms. Which contains the application specific functionality. On top of DAL, I have a Business Logic Layer (BLL) On top of the data layer, I have my Data Access Layer (DAL) which has all the data access functionalities (using ADO.NET). I have a Data Layer that provides database related functionalities. This application is designed using an n-tier architecture.
Let's start by talking about the architecture of this application. Also it uses ADO.NET and I agree an ORM could have been used to do thisīut I like the power and control that ADO.NET provides and so I used it instead.
The good thing about this application is that it follows proper n-tier architecture. And to some people, the functionality might also seems simple like in a student project. There is no design on presentation layer (I am pretty bad at that). The database design is very simple and not optimized. This application is a very simple application sending messages to other registered users of the site. There might be some small businesses wanting such an application and they will perhaps be able to use this application with some changes. The idea behind this small project that I made in couple of hours is to provide a skeleton for such an application. Since we didn't have anyone to write one, we ended up using GMail for this. This made me realize that one of my previous employers also wanted such an application just for internal communication It was more of a messaging system where users can use their credentials to log into the site and can send/receive messages from other users of the site. When I asked himĪbout what he needed, he said he needed an email application that will only work inside an organization and there is no need to send/receive emails to other email providers.
MESSAGE INBOX APP HOW TO
Last week someone asked a question in "The Code Project - Quick Answers" section on how to develop an email application. This article contains a small email application which is developed using ASP.NET, C#, and ADO.NET.