使用下面的代码，如何在SQLiteConnetion对象中设置代码？
public SQLiteConnection dbConnection = new SQLiteConnection();
| 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 | string fileName ="test.s3db";
string sourcePath = @"E:\File\DMS\DAL\Model";
string targetPath = @"C:\ProgramData\CompanyName\appName";
string sourceFile = System.IO.Path.Combine(sourcePath, fileName);
string destFile = System.IO.Path.Combine(targetPath, fileName);
if (!System.IO.Directory.Exists(targetPath))
{
System.IO.Directory.CreateDirectory(targetPath);
}
System.IO.File.Copy(sourceFile, destFile, true);
if (System.IO.Directory.Exists(sourcePath))
{
string[] files = System.IO.Directory.GetFiles(sourcePath);
} |
这种方法来复制数据库：
| 1
2
3
4
5
6
7
8
9
10 | public static void BackupDatabase(string sourceFile, string destFile)
{
using (SQLiteConnection source = new SQLiteConnection(String.Format("Data Source = {0}", sourceFile)))
using (SQLiteConnection destination = new SQLiteConnection(String.Format("Data Source = {0}", destFile)))
{
source.Open();
destination.Open();
source.BackupDatabase(destination,"main","main", -1, null, -1);
}
} |
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
