C# SQL database console application

Question

I'm not very familiar with the console application but i think its kind a interesting subject to learned. I searched for tutorials and references related to connecting MySQL database in console but no luck. So i just try and error. Please correct me I'm wrong..

I had an application where when user run the program, it'll store values to database. In the Form Application, it runs well(no doubt). Now with the same approach, i want it to be run it in the console application. So, I create new project in console and just copy, do some editing on the codes and put in Main. Luckily, the code running well.

My concerns are, is it what i'm doing is write? the command for the form can be used in console? What are differences between this two? is this the better approached?

Any advice and references are very helpful.

Answer 1

There's very little difference between console apps and WinForms apps in terms of the pieces of code which actually interact with the database.

One significant difference between them in the surrounding code is that you'd usually use a different thread to perform the database access in a WinForms app, to avoid blocking the UI thread. If you're just writing the data out to a console, there's no need for that.

Answer 2

Console applications are typically designed without a graphical user interface. A console application is run from the command line with input and output information being exchanged between to and from the console window, this makes the console application a great way to learn new programming technique without having to be concerned with the user interface.