I'm developing a small C # system that will eventually be deployed to client computers by accessing a local database.
Initially I was going to use SQL Server, but I would have to install it next to the system, and it gets kinda heavy for just a simple system.
I wanted an indication of DBMS that is good and simple and light, to use as a database in this C # application. I need only one computer to have the database and the other PCs with the system find and use this bank over the network.
Hello, since I had to create a simple application in which the user did not need to use a bank and solved it with SQL Lite . It is a simple database that does not need to be installed by the end user.
If you do not need this, I suggest reading about SQL Express , which is a more compact version of SQL Server , perfect for smaller applications.
For the scenario described, the solution would be SQLite , it does not need to install, it's built into the application itself.
Some people use LocalDB , but it is often less suitable than SQLite for remote access. The same can be said of the SQL Server Compac that is practically obsolete.
The problem is that you can not have other external applications accessing the same SQLite database. You would have to write an application server to control access . I like the idea, but not everyone who knows how to do it. There is no free lunch. My preference is to write a server for it.
There are some other options that fall into the same problem. Could do
If you want a server ready, you have nothing to do, you will have to install it. What you can do is automate the installation. SQL Server Express is a free and interesting option, but it has limitations of use. Some find it easy to install Firebird . But be careful not to install the shipment that is extremely limited and can not be used for simultaneous access. Even the full version tends to have scale problems. After that, just customizing a way to install MySQL or PostgreSQL that can be mounted the way you want.
In fact if you want a server I do not see so much disadvantage so have to install it. It is much more important to have option without installing on desktop or mobile client, there SQLite is the best option. Even with server in general my choice is by SQLite always it stands.
These options allow use with the Entity Framework. There may be options that are not supported.
There is a certain dichotomy between not installing and having external access. Except for crazy solutions or totally built by you, only SQLite tailored to work as server will solve. In practice even this case will have to install your server.
Otherwise making use of the cloud is the only way out so you do not have to install the database. Of course this has its drawbacks as well.
If you want a complete database like SQL Server, installing it is the least of the problems. You even have to buy it.
I would like an indication of DBMS that is good and simple and light, to use as a database in this C # application. I need only one computer to have the database and the other pcs with the system find and use this database over the network.
In this case you install the database access software together with the application, and on the computer that chooses to work (as well) as database server , you can install SQL Server Express. ODBC is an option for connecting the application to the database.
Only one of the computers will need to install the DBMS.
The Express Edition of SQL Server has some limitations, mainly the maximum size of each database (up to 10 GB) and maximum memory per instance (1 GB, in practice 1,410 MB).
In the free software line you will find, among many, MariaDB .
Suggested reading:
Hello,
As I said it was a lightweight DBMS and need a server that has these functions all I advise: XAMPP is a server that contains Apache, MariaDB (database), PHPMyAdmin (can be your DBMS even though I use MariaDB in terminal), PHP, and Perl is available for most OS's.
I hope I have helped
