public static string getdefaultsqliteconnectionstring()
        {
            sqliteconnectionstringdto _connectionstringdto = new sqliteconnectionstringdto();

            _connectionstringdto.sqlite_database_path   = System.Configuration.ConfigurationManager.AppSettings["sqlite_database_path"];
            _connectionstringdto.database               = System.Configuration.ConfigurationManager.AppSettings["sqlite_database"];
            _connectionstringdto.sqlite_db_extension    = System.Configuration.ConfigurationManager.AppSettings["sqlite_db_extension"];
            _connectionstringdto.sqlite_version         = System.Configuration.ConfigurationManager.AppSettings["sqlite_version"];
            _connectionstringdto.sqlite_pooling         = System.Configuration.ConfigurationManager.AppSettings["sqlite_pooling"];
            _connectionstringdto.sqlite_fail_if_missing = System.Configuration.ConfigurationManager.AppSettings["sqlite_fail_if_missing"];

            string CONNECTION_STRING = buildsqliteconnectionstringfromobject(_connectionstringdto);

            return(CONNECTION_STRING);
        }
        static string buildsqliteconnectionstringfromobject(sqliteconnectionstringdto _connectionstringdto)
        {
            string base_dir         = Environment.CurrentDirectory;
            string database_dir     = base_dir + _connectionstringdto.sqlite_database_path;
            string dbname           = _connectionstringdto.database;
            string database_version = _connectionstringdto.sqlite_version;
            string db_extension     = _connectionstringdto.sqlite_db_extension;

            dbname = dbname + "." + db_extension + database_version;

            if (!Directory.Exists(database_dir))
            {
                return(null);
            }
            else
            {
            }

            string full_database_name_with_path = database_dir + dbname;
            string _secure_path_name_response   = _connectionstringdto.sqlite_database_path + dbname;

            if (!File.Exists(full_database_name_with_path))
            {
                return(null);
            }
            else
            {
            }

            string CONNECTION_STRING = @"Data Source=" + full_database_name_with_path + ";" +
                                       "Version=" + _connectionstringdto.sqlite_version + ";" +
                                       "Pooling=" + _connectionstringdto.sqlite_pooling + ";" +
                                       "FailIfMissing=" + _connectionstringdto.sqlite_fail_if_missing;

            return(CONNECTION_STRING);
        }