FireLance/GSMParser/GsmMgr.cs

using Microsoft.Data.Sqlite;
using System;
using System.IO;
using Firelance.Interfaces;

namespace Gsm
{
    public class GsmMgr : IFlcBaseDBConnection
    {
        private SqliteConnection _database;
        public SqliteConnection Database
        {
            get { return _database; }
            private set
            {
                _database = value;
                RO.SetDatabaseInstance(_database);
            }
        }
        public GsmRO RO = new GsmRO();

        public void OpenConnection(string dbLocation, int port)
        {
            if (File.Exists(dbLocation) == false)
            {
                throw new FileNotFoundException(dbLocation);
            }

            Database = new SqliteConnection($"Data Source={dbLocation};Mode=ReadOnly");
            Database.Open();
        }

        public void CloseCurrentConnection()
        {
            Database.Close();
        }

        public bool IsConnectionOpen()
        {
            return Convert.ToBoolean(Database.State);
        }
    } 
}