ASP CRUD C# Microsoft SQL Server Database
Budget: $10 – $30 USD
ASP CRUD C# Microsoft SQL Server Database
I want a simple ASP And C# Server side scripting project that should perform all CRUD operations.
MVC Scaffolding.
Use Migration to create an SQL server Database on azure.
Push the app to GitHub.
Deploy on online Azure.
SQL Server database table with a primary key and other with a foreign key. Only a minimum of two tables to show the relationship between primary and foreign keys is required.
You will connect to my laptop via TeamViewer or any desk to code and run the code using Visual Studio 2020 and Microsoft SQL server management studio 18. Eventually, you will push the code to azure to create an online website.
A connection string will be used to connect to the online azure database.
You can use a migration to create the database and the tables automatically.
It's an inventory management system with two tables. Inventory and Single item table.
Inventory table can have columns like :
1. Item ID (Primary Key)
2. Item name
3. Description
4. Vendor
5. Cost Per Item
6. Stock Quantity
Item/Product table:
1. Item ID(Foreign Key)
2. Item Name.
3. Item Description.
Example of GUI
https://prnt.sc/i6N7xkuRC01D
I want a simple ASP And C# Server side scripting project that should perform all CRUD operations.
MVC Scaffolding.
Use Migration to create an SQL server Database on azure.
Push the app to GitHub.
Deploy on online Azure.
SQL Server database table with a primary key and other with a foreign key. Only a minimum of two tables to show the relationship between primary and foreign keys is required.
You will connect to my laptop via TeamViewer or any desk to code and run the code using Visual Studio 2020 and Microsoft SQL server management studio 18. Eventually, you will push the code to azure to create an online website.
A connection string will be used to connect to the online azure database.
You can use a migration to create the database and the tables automatically.
It's an inventory management system with two tables. Inventory and Single item table.
Inventory table can have columns like :
1. Item ID (Primary Key)
2. Item name
3. Description
4. Vendor
5. Cost Per Item
6. Stock Quantity
Item/Product table:
1. Item ID(Foreign Key)
2. Item Name.
3. Item Description.
Example of GUI
https://prnt.sc/i6N7xkuRC01D