Hi, I study c # sockets and for practice there is such an idea. There are two simple applications server and client. The client sends a request in the form of a string in response to the same line comes. I want with the help of such requests to organize the unloading of the file from the database. As I see it. On the example of the picture. 1.Send the request "Machine" 2.Server received the request "Machine". 3. Made a request

select * from image where name = 'Машина'

in the database and if the picture is found, then return it as an answer to the request, otherwise return the answer with an error that there is no picture. So I have a few questions. 1. Is it possible to store files in a SQL database, or you need to use another database. 2. How to pull a picture from the database and send it as a request. I understand that this will be sent as an array of bytes. But not understanding how. The transfer will go as it will later and it will be necessary to use a StreamReader or not. Who can make such a thread know or have a clue?

Happy New Year!!!

  • one
    didn't you think about how to implement this in the form of a web application? server - web server, client - browser? - Mikhail Vaysman
  • I want to use wpf on c # - Sasuke
  • window application of the type will be - Sasuke
  • one
    even in this form, you can implement the server as a web server and communicate with it via REST. This will be convenient, since the necessary libraries already exist. - Mikhail Vaysman
  • You can give a reference to the information or describe in more detail how you see the solution to this problem - Sasuke

0