C# Web & Desktop Integration

The project involves building two tightly-coupled applications that share the same SQL Server back-end:
• an ASP.NET-based web application for browser access, and
• a Windows desktop client for on-site workstations.

Both fronts must read from and write to the same database tables so users experience identical business logic and data integrity no matter where they sign in.

Core requirement
The system has to communicate in real time with a pharma instrument connected over USB/COM (exact protocol documentation will be provided). I will supply sample command sets and expected response frames; the software must initialize the device, capture measurement data, validate it, and commit the results to SQL.

Typical workflow
1. User starts a test from either front-end.
2. The application sends the appropriate command string to the instrument.
3. Incoming data are parsed, displayed, and stored.
4. An automatic acknowledgement is returned to confirm completion.

Important notes
• C#, .NET (Framework or 6/7), ADO.NET/EF Core, and SQL Server are mandatory tools.
• The web side can be WebForms or MVC; whichever you prefer, provided it mirrors the desktop logic.
• Source code must be cleanly commented so another developer can extend device support later.
• I’ll run the acceptance test on my lab PC with the actual hardware; success means the instrument completes a full cycle and the record appears in the database with the correct timestamp and values.

Deliverables
- Complete Visual Studio solutions for both projects
- SQL schema (tables, stored procedures, seed data)
- README with setup instructions and the device communication spec
- A short video or screenshots demonstrating a finished test run through each interface

If you have previously integrated laboratory or industrial equipment through serial/USB protocols, that experience will be valuable here.