Setup

• Install .Net8.0
• Install deps: dotnet restore
• Run Migrations: cd CustomerAPI && dotnet ef database update && cd -
• Run the app: cd CustomerAPI && dotnet run
• Run the script: cd CustomerDataImporter && dotnet run
• Explore REST urls from swagger (http://localhost:5190/swagger/index.html)

Try these OData urls:

- http://localhost:5190/odata/Escos?$select=Name&$expand=Customers($filter=Id gt 432767)&$orderby=Name desc
- http://localhost:5190/odata/Escos?$select=Name&$expand=Customers($filter=Id gt 432767)&$orderby=Name asc
- http://localhost:5190/odata/Escos?$select=Name&$expand=Customers($filter=Id eq 432766)
- http://localhost:5190/odata/Escos?$select=Name&$expand=Customers($filter=FirstName eq 'Mushtaq')
- http://localhost:5190/odata/Escos?$expand=Customers
- http://localhost:5190/odata/Escos?$select=Name&$expand=Customers
- http://localhost:5190/odata/Escos?$apply=aggregate($count as Count)
- http://localhost:5190/odata/Escos?$apply=aggregate(Id with sum as IdTotalSilly)
- http://localhost:5190/odata/Escos?$select=Name
- http://localhost:5190/odata/Escos/$count
- http://localhost:5190/odata/Escos