Description: |
Expected duration: 3 - 4 weeks 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 placeholders 3. Packaged installer (self-contained EXE or MSI with silent-install support) 4. Git repo with clear commits & branching 5. 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. |