3
I developed a C# Windows Forms application with Visual Studio 2013 and Firebird database, but I would like to make a small application to facilitate access to the system. However in this application 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 database? And this connection follows the same scheme as Windows Forms? How do I do this?
3
The question is a little wide but I will answer what it gives.
It’s possible if there are no network blocks. Even if you don’t have it, it’s not ideal to give access to the database for applications you don’t have control over how they run. Many will say that it is better to have a middleman in any situation. That is, having a solution using real client-server architecture and not having the database working as the application server.
The solution for these cases is to have an application server that accesses the database and provides the data requested by the application. This server can be based on web, so ensures compatibility with virtually any network, after all port 80 is always open.
If you choose to use web technology (even if you don’t 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 (only use this version for new projects, previous died).
Browser other questions tagged c# .net visual-studio-2013 windows-phone firebird
You are not signed in. Login or sign up in order to post.
So I should develop like a website where the data would be stored and so access them in the Windows Phone application and in the Windows Forms application through this webapi? But I can still use Firebird or should I switch to sql? Thanks so much for the help!
– André Morais Martins
It’s not that it’s a website, is something similar. It uses the same technology but will not build HTML pages for browser (well, you can even do this too, if you wish). But there are other technologies, even a little more efficient. Of course they have their own disadvantages. Then if you are going to change your Winforms application to access this application, it is your decision. I would not initially. Leave it as it is and one day you’ll see if it’s worth it. Firebird is SQL. You can keep using it. These were general ideas.
– Maniero
Got it., but I think I asked wrong, as I will have to host this web application on some server most likely. Therefore it is possible to continue using Firebird or I must switch to Sql Server?
– André Morais Martins
Not necessarily, but it’s obvious that the app will have to have access to the app somewhere. It would be the same if you were to make the direct access to the database. You can continue using Firebird, this does not change anything.
– Maniero
Okay then, thank you so much for your help!
– André Morais Martins
If you have more specific questions, ask.
– Maniero
Dude, I have new doubts. Within my project (Solution) there are some parts, so I have the desktop part that has the classes and repositories, and I have the part of the web api that I made based on this site (http://csharpbrasil.com.br/criando-e-consumindo-web-api-parte-1/). So I want to ask you if the way I did the api is correct, why did you add a lot of references? And now I need to develop the Windows Phone app, as I consume the data of this api in the app, because what I’ve seen so far is necessary to use the classes, but my classes are in the other part of the project?
– André Morais Martins