I developed a C # Windows Forms application with Visual Studio 2013 and with Firebird database, but I would like to make a small application to facilitate access to the system. But in this application it would be necessary to access the same application database to insert and query some records.
Is it possible to connect this application to the Firebird bank? And does this connection follow the same Windows Forms schema? How do I do this?
The question is a bit broad but I will answer what it gives.
Possible up to is if there are no network locks. Even if it does not, it is not ideal to give access to the database for applications that you do not have control of as they are running. Many will say that it is better to have an intermediary in any situation. That is, having a solution using real client-server architecture and not having the database running as the application server.
The solution to these cases is to have an application server that accesses the database and provides the data requested by the application. This server can be web-based, thus ensuring compatibility with virtually any network, after all port 80 is often always open.
If you choose to use web technologies (even if you do not have a website accessing), you will need to learn how to program with ASP.Net WebAPI or something that does the same function. The new version of ASP.Net integrated MVC with WebAPI .
