SQLite is the default database for ease of deployment and quick to start. However, it can be switch to different any database supported by Entity Framework Core such as MySQL, MSSQL, PostgreSQL, CockroachDB etc. Read this for how to change database
SQLite data file is stored in database folder. Connection string is found in appsettings.json