SQLite 文件使用 Memory 模式

weixin_34161083

于 2015-10-27 19:24:00 发布

阅读量7.2k

点赞数

文章标签：数据库 python c#

原文链接：https://my.oschina.net/u/156096/blog/522807

版权

2019独角兽企业重金招聘Python工程师标准>>>

SQLiteConnection source = new SQLiteConnection("Data Source=c:\\test.db");
source.Open();

using (SQLiteConnection destination = new SQLiteConnection("Data Source=:memory:"))
{
  destination.Open();               

  // copy db file to memory
  source.BackupDatabase(destination, "main", "main",-1, null, 0);
  source.Close();

  // insert, select ,...        
  using (SQLiteCommand command = new SQLiteCommand())
  {
    command.CommandText = "INSERT INTO t1 (x) VALUES('some new value');";

    command.Connection = destination;
    command.ExecuteNonQuery();
  }             

  source = new SQLiteConnection("Data Source=c:\\test.db");
  source.Open();

  // save memory db to file
  destination.BackupDatabase(source, "main", "main",-1, null, 0);
  source.Close();               
}

转载于:https://my.oschina.net/u/156096/blog/522807