How to get data from Myslq on demand and pass everything into data to C# application and write everything to SQLite?

Question

PHP

There is a portal in php/Mysql, there is also an application in c#. The task is as follows, you need to get data from the Myslq database on request and transfer everything to the data in the C # application and write everything to SQLite. Records about 5000 lines. Tell me in which direction to move, what technologies currently exist and are the most popular?

Answer 1

Well, lean towards "SOAP, Rest". What is the question?
All these buzzwords were invented by miserable javers and sharpeis who never saw an HTTP request in their eyes. Which, in essence (in the company with RPC) and represent. All you need to do is send an HTTP request to the random server. Preferably with some kind of authorization. And get an answer. The data transmission format is the tenth question. Whatever you want, pass it on. Though comma delimited, though HTML. Moreover, what is needed, as I understand it, is a bare dump, and not separate samples.
From the PHP side, the simplest format would be JSON.
will be sufficient.
If you don’t know how to make HTTP requests from a sharp, and you want the opposite - puff spitting data on the crown - then curl

Answer 2

The ultimate goal is not entirely clear:
either it will be a one-time conversion of mysql to sqlite,
or this is how data caching is implemented, and unloading will be periodic.
If it's a one-time conversion, then there's a list of converters .