We need a C# developer to build a Windows console-based “On-Premise Agent” that will:• Authenticate to our central API (POST /api/login) via username/password and obtain a Bearer token• Fetch SQL query, field mappings & endpoint URL (GET /api/fetch-query)• Query an on-premises SQL Server and retrieve data• Map SQL fields to the API payload schema• Send data in batches of 1,000 records to POST /api/receive-data• Retry up to 5x on login, fetch-query, SQL execution, and data-send failures• Log every step (timestamped, daily rolling files) and report errors to POST /api/receive-error-data• Be schedulable via Windows Task Scheduler and runnable manually
Deliverables:1. C# console app targeting your chosen .NET runtime (.NET 6 or .NET 4.8)2. Config file template (appsettings.json) with placeholders3. Packaged installer (self-contained EXE or MSI with silent-install support)4. Git repo with clear commits & branching5. Unit/integration tests (≥70% coverage)6. README (build, deploy, troubleshoot)
To apply, please include:• Links to similar projects or GitHub samples• Your preferred .NET runtime & logging framework• Estimated hours (or fixed price) and hourly rate
We’ll share the full API spec and sample SQL schema once you’re shortlisted.
Success story sharing