C# (CSharp) Simple.Sqlite.SqliteDB.ExecuteQuery Exemples

Exemple #1

        public static void run(Simple.Sqlite.SqliteDB db)
        {
            db.CreateTables()
            .Add <AuxilioModel>()
            .Commit();

            string pasta = "";

            while (!Directory.Exists(pasta))
            {
                Console.WriteLine("Entre com a pasta:");
                pasta = Console.ReadLine();
            }

            {
                // recovery from where it stopped
                var allNis = db.ExecuteQuery <string>("SELECT NIS FROM AuxilioModel WHERE NIS IS NOT NULL", null)
                             .Select(nis => long.Parse(nis));
                uids = new HashSet <long>(allNis);
            }

            processaPasta(pasta, db);
        }