Table of Contents
This is a C# CRUD (Create, Read, Update, Delete) project built using the following technologies:
- C# for the main programming language
- Entity Framework Core for data access and management
- Razor Pages for building the web interface
- SQL Server for storing the data
- ClosedXML for exporting data to Excel
- Bootstrap for styling and layout
The project is designed as an exercise for an interview for a developer position. It is a simple web application that allow CRUD operations on a database of Buildings, Customers and PartNumbers tables. Additionally, the project has implemented functionality to export data to excel using ClosedXML library. The user interface is built using Razor Pages and Bootstrap for a responsive and user-friendly experience. The goal of this project is to showcase the developer's (Me) skills in using the above technologies.
The database:
To get a local copy up and running follow these simple steps.
-
Visual Studio 2022
Download and Install https://visualstudio.microsoft.com/vs/
-
ASP.NET Core Runtime version 7.02
-
Download and Install https://dotnet.microsoft.com/en-us/download/dotnet/7.0
-
SQLServer 18>
-
Download and Install https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
- Clone the repo
git clone https://github.com/PhoenixIgnis/Dot_NET_CRUD_Project.git
- Install Packages via NuGet
install-Package ClosedXML
install-Package Microsoft.EntityFrameworkCore.SqlServer
install-Package Microsoft.EntityFrameworkCore.Tools
- Create the local SQLServer Database
Update-Database
- Initialize The Database
Run the program and data will be seeded automatically.
- Run the project in Visual Studio
Distributed under the Mozilla Public License 2.0. See LICENSE.txt for more information.
Isaac Rodriguez - [email protected]
Project Link: - .NET CRUD Project