Car Insurance Database
Live Demo
Source Code
This project utilized ASP.NET MVC to make CRUD pages and Entity Framework as the Database transport.
Project DetailsInfo behind this project
In this assignment, I learned to build databases with ADO.NET, then transitioned to Entity Framework. I developed a CRUD (Create, Read, Update, Delete) web application in ASP.NET, where application users can add or modify insurance entries and receive a calculated quote.
Making the Live Demo
The Web Server (the one hosting this website) runs on on limited assemblies for more efficiency and in order to make the live demo I had to make some adjustments for the code to make it work. Although the server is not an ASP.NET environment, it successfully replicates the required operations. The database implementation was also changed to a use a more lightweight ADO.NET-based library for more efficient storage and resource consumption.
Technologies UsedWhat engines, frameworks and tools were used
Hypertext Markup Language (HTML)
HTML is used to define the general hierarchy and relationships between elements on a webpage. HTML itself, usually doesn't look very presentable and looks like a something you'd find in the 90s, so you'll need to use CSS to add color.
CSS is used in combination with HTML, it is used to "paint" the canvas that was built with HTML. However, CSS is not a programming language and does not provide any programmable functionality.
C# (pronounced Sea-Sharp) is an Object Oriented Programming (OOP) language that was developed by Microsoft in 1999. It is designed to work with the .NET Framework, which provides a wide range of libraries and APIs for tasks such as database interaction, networking, and graphics manipulation. C# is widely used for building Windows applications, web services, and mobile apps.
I utilized C# in this project by writing ..
- .. writing two CSHTML Views
- .. writing a Controller that handles and supplied date to the Views
- .. wrote a ADO.NET implemenetation for storage
- .. wrote a Entity Framework implementation for storage
SQL (Structured Query Language) databases are Relational Database Management Systems (RDBMSs) that store data in a structured format using tables, rows, and columns, allowing for efficient querying and manipulation of data. Essentially, it is a spreadsheet used by applications to efficiently find, modify and store data.
Git is a Version Control System (VCS) used to track changes to a codebase over time. GitHub is a centralized Git service owned by Microsoft that lets developers easily collaborate with each other. GitHub also offers other tools for development such as Boards (named GitHub Projects), Issues and automation.
The source code for this project available on github.com