C# + MySQL how to deal with the necessary tools or abandon it?

I

iamserge2019-08-21 12:24:49

MySQL

iamserge, 2019-08-21 12:24:49

In general, the situation is simple, there is a need to store data in small volumes (mainly double, int, DateTime) from the accounting department in the database, because indexing and so on are already very relevant, there is too much data, and queries are getting smarter and trickier. Well, I had to think about the fact that I still need a DBMS and I have no way out ...
At the same time, I used a bunch of Mysql + phpMyAdmin, as part of LAMP, but those times pass and you need to either bring it to the required state, or look for more solution paths. In general, the question is how can I:
1. Use MySQL differently, but still have a visual data viewer, but not tied to LAMP, but a desktop one.
2. How to connect with all this from C #, otherwise it obviously doesn’t catch stars from the sky, that is, it’s less popular, and it definitely has more competitors ... Well, I won’t find in C # such an implementation that is used everywhere in PHP , and then suddenly became not so accessible. So far I have found something similar , but not at all for MySQL ...
In general, the question is how to switch to MySQL now but within the framework of C #, well, is there any need to abandon it, maybe it's hopeless. And here, for example, MS SQL Server is the best choice?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

alekseyHunter, 2019-08-21
@iamserge

how to switch to MySQL now but within C#

It is required to install drivers to connect to this database, then we connect and work.
Where is the best place to work? I'm friends with MySQL only on the web, on the desktop only MS SQL Server.

S

Stanislav Valsinats, 2019-08-21
@jesterOK

Well, firstly, the driver is not scary. It's just a file\script that provides the ability to connect and send queries to the database.
For example, HERE
If the project is small, then it can look towards CompactSQL (I have never worked with it, but I know that Melkosoft software uses it as an internal database),
or SQLLite - the project is actively developing, though not so functional, but it all depends on the needs.
From the free one, there is also MS SQL Express - download the latest version, limit on the number of cores (one is supported and used, no matter how many are installed). Restriction on the size of a DB - to 10 Gb as far as I remember.
dare