ASP.NET REST API with MSSQL and Python integration for ETIC project

• ASP.NET RESTful API with MSSQL database
• Python Client that interacts with the API via CRUD operations

• Visual Studio (Optional)
• .NET 5.0
• Python 3.9
• SQL Server

git clone https://github.com/AKhalil22/ETIC-Database-Project.git

cd ETIC-Database-Project
dotnet restore

Update DefaultConnection String under Api > appsetting.json, replacing the Server and Database values with your own

"ConnectionStrings": {
	"DefaultConnection": "Data Source={PCNAME}\\SQLEXPRESS;Initial Catalog={DATABASENAME};Trusted_Connection=True;MultipleActiveResultSets=true"
  }

Initialize database connection

dotnet tool install --global dotnet-ef
cd Api
dotnet ef migrations add init

Should look like this:

Then run:

dotnet ef database update

Refresh your database & dbo.Expenses should be created within your database!

Run API:

dotnet run

In a new terminal:

cd Client
pip install -r requirements.txt
python main.py