/// <summary> /// 数据库通用方法 /// </summary> /// <typeparam name="T">数据集合类型</typeparam> /// <param name="datas">数据集</param> public static void SaveData <T>(IEnumerable <T> datas) where T : CC.ORM.SqlDataBase, new() { Console.WriteLine("开始数据库事务..."); var dc = ORMHelper.DefaultDataFactory.Create(); dc.BeginTransaction(); foreach (var item in datas) { ORMHelper.InsertOrUpdate(item, dc); } dc.Commit(); dc.Close(); }
/// <summary> /// 数据库录入 /// </summary> /// <param name="list">缓存列表</param> static void DataToBase(List <baidutb> list) { MysqlFactory.Instance.DefaultConnStr = MysqlFactory.GetConnStr("localhost", "root", "456123", "fortest"); ORMHelper.DefaultDataFactory = MysqlFactory.Instance; DataControl dc = ORMHelper.DefaultDataFactory.Create(); dc.BeginTransaction(); foreach (var item in list) { ORMHelper.InsertOrUpdate(item, dc); } dc.Commit(); dc.Close(); }