Exemplo n.º 1
0
 public static void OpenConnection()
 {
     if (!File.Exists(SqLiteBase.DbFile))
     {
         //CreateDatabase();
     }
     if (Connection != null && Connection.State == ConnectionState.Open)
     {
         Connection.Close();
     }
     Connection = SqLiteBase.SimpleDbConnection();
     Connection.Open();
 }
Exemplo n.º 2
0
        public void CreateDatabase(List <Type> lista)
        {
            var sql = String.Empty;

            foreach (var item in lista)
            {
                sql += GetSQLClass(item);
            }

            using (var cnn = SqLiteBase.SimpleDbConnection())
            {
                cnn.Open();
                cnn.Execute(sql);
            }
        }