Newlife.Xcode

 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.事务处理

原文地址:https://www.cnblogs.com/mbaymax/p/13253200.html