I need a LoRa designer to create an implementation plan

I want to put a LoRaWAN in place that includes lights (which we source together), a LoRa gateway (which is recommended by you), configuration of network and integration into a SQL based web app. I run the server (ms windows server with iis) so we can build a web service or whatever is easiest but all incoming data goes into MSSQL db and all outgoing data initiates from same. The solution should be robust enough to allow for other devices to be added later.