DESKTOP
BaytIntegration — ERP Desktop Toolkit
An auto-updating desktop integration toolkit for Bay.t ERP, built on a “read via SQL, write via API” approach.
- CATEGORY
- Desktop
- STACK
- .NET 8
- WinForms
- DevExpress
- Dapper
- Velopack
- SQL Server
- NOTES
- v1.5.5 · WinForms · auto-updating
- Desktop toolkit.NET 8 · WinForms · DevExpress
- Read pathSQL · DapperWrite pathPartner API
- Bay.t ERP
01Problem
Bay.t ERP's Partner API was limited and nearly undocumented; field staff needed to create carts and orders on the ERP quickly.
02Solution
I worked out the undocumented database schema and API payload structures by studying them, and turned the findings into a permanent knowledge base. I built a Clean Architecture toolkit with .NET 8 + WinForms + DevExpress and set up auto-updates with Velopack.
03Technical Details
- A “read via SQL, write via Partner API” hybrid integration pattern
- Auto-updates and a launcher via Velopack
- Multi-company / multi-database support, BCrypt-protected tool authorization
- Race-condition, type-binding and connection-cache issues found at customer sites solved with defensive patterns
- Version tracking with semantic versioning (v1.5.5)