/// <summary> /// 批量插入 /// </summary> /// <param name="list"></param> /// <returns></returns> public bool BatchInsert(List <TLogsDebugLog> list) { //使用SqlBulkCopy var result = false; using (var conn = DapperHelper.CreateConnection()) { //list转DataTable var dt = LogNewHelper.ConvertToDataTable(list); using (var sqlbulkcopy = new SqlBulkCopy((SqlConnection)conn)) { sqlbulkcopy.BatchSize = list.Count; sqlbulkcopy.DestinationTableName = "t_logs_debug_log";//tableName for (var i = 0; i < dt.Columns.Count; i++) { sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName); } sqlbulkcopy.WriteToServer(dt); result = true; } } return(result); }
static DebugLogManager() { //Autofac初始化 container = LogNewHelper.BuildAutofacContainer(); using (var scope = container.BeginLifetimeScope()) { _debugLogService = scope.Resolve <ILogsDebugLogService>(); } }
public MainService() { tasks = new List <Task>(); cancelToken = new CancellationTokenSource(); //Autofac初始化 container = LogNewHelper.BuildAutofacContainer(); //rabbitMQ初始化 var config = System.Configuration.ConfigurationManager.GetSection("rabbitMQ") as RabbitMQConfigurationSection; rabbitMQProxy = new RabbitMQWrapper(new RabbitMQConfig { Host = config.HostName, VirtualHost = config.VHost, HeartBeat = 60, AutomaticRecoveryEnabled = true, UserName = config.UserName, Password = config.Password }); }