1.连接绑定与切换
public void LoadData()
{
int lastdbid = 0;
int count = 0;
int totalCount = 0;
DAL.AddConnStr("IgImage",
DbSetting.Current.IgImageConn, null, "SQLite");
totalCount = IgImage.Meta.Count;
while (count < totalCount)
{
DAL.AddConnStr("IgImage",
DbSetting.Current.IgImageConn, null, "SQLite");
IgImage.Meta.ConnName= "IgImage";
IList<IgImage> igimgs = IgImage.FindById(lastdbid);
foreach(var item in igimgs)
{
lastdbid = item.nId;
string database = item.tCrtTime.ToString("yyyyMMdd");
string connStr = string.Format(DbSetting.Current.DataPath + $"{database}.db");
DAL.AddConnStr("IgImage", connStr, null, "SQLite");
IgImage.Meta.CreateSplit(connStr, IgImage.Meta.TableName);
item.Insert();
count++;
}
}
}
2.SQLite指定目录,不使用默认Data目录
3.是否支持存储过程
4.事务处理