Blog: Foscam VMS not showing device username/password: Program.cs

using System;
using System.Text;
using System.Data.SQLite;

namespace MyApp
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
            Console.WriteLine("The current time is " + DateTime.Now);

            string _sDatabasePassword = "WeLcOmE2IvYiOt'sVMS.db";

            string cs = "Data Source=C:\\Users\\info\\MyApp\\VMS.db;Password=" + _sDatabasePassword;


            var con = new SQLiteConnection(cs);
            con.Open();

                        /* Validate succesfull access to database */
            string stm = "SELECT name FROM sqlite_master WHERE type='table';";
            var cmd = new SQLiteCommand(stm, con);
            string result = cmd.ExecuteScalar().ToString();
                        Console.WriteLine($"SQLite result: {result}");

            // Remove Password from database
            con.ChangePassword(String.Empty);

            con.Close();
        }
    }
}