How to create a local MS SQL database?

Question

SQL

Hello! I need to write a home bookkeeping program using a DBMS. After I understood the topic to some extent - I decided to choose MS SQL server express. There it is possible to create a local database, which is handled using the Microsoft.Data.SqlClient package. At the same time, I work with the local server (localdb)\MSSQLLocalDB.

Question - is it possible to work with a local database file directly on the hard drive using SQL? Without having to install MS SQL server express?

After all, do I understand correctly that my program will not work on any machine?

Answer 1

Get SQLite. The database lives in one file, EF works great with it. You don't even have to change anything in the project, just change the provider, specify where the base is and roll the migration.

Answer 2

Just use Microsoft SQL Studio Management