public void saveLlcTlliSessionDocumentSet(string sqlconn) { TcpDbContext context = null; try { context = new TcpDbContext(sqlconn); context.Configuration.AutoDetectChangesEnabled = false; int count = 0; LlcTlliSessionStaging tls = new LlcTlliSessionStaging(); foreach (var llc in tls.mongo_LlcTlliSessionStaging.QueryMongo()) { ++count; context = context.AddToContext(context, llc, count, bulksize, true, sqlconn); } context.SaveChanges(); } finally { if (context != null) context.Dispose(); } Console.WriteLine("LlcTlliSessionDocument->TcpDbContext->ok"); }
public void saveLacCellBvciETLDocumentSet(string sqlconn) { TcpDbContext context = null; try { context = new TcpDbContext(sqlconn); context.Configuration.AutoDetectChangesEnabled = false; int count = 0; LacCellBvciETL lcbs = new LacCellBvciETL(); foreach (var cell in lcbs.mongo_LacCellBvciETL.QueryMongo()) { ++count; context = context.AddToContext(context, cell, count, bulksize, true, sqlconn); } context.SaveChanges(); } finally { if (context != null) context.Dispose(); } Console.WriteLine("LacCellBvciETLDocument->TcpDbContext->ok"); }
private static void CreateTcpDb() { using (TcpDbContext db = new TcpDbContext(sqlconn)) { if (db.Database.Exists()) db.Database.Delete(); db.Database.Create(); Console.WriteLine(db.Database.Connection.ConnectionString); } GC.Collect(); Console.WriteLine("CreateTcpDb,Finish"); }
public TcpDbContext AddToContextCon(TcpDbContext context, int count, int commitCount, bool recreateContext, string sqlconn) { if (count % commitCount == 0) { Console.WriteLine(count); context.SaveChanges(); if (recreateContext) { context.Dispose(); context = new TcpDbContext(sqlconn); context.Configuration.AutoDetectChangesEnabled = false; } } return context; }
public TcpDbContext AddToContext(TcpDbContext context, LacCellBvciStagingDocument entity, int count, int commitCount, bool recreateContext, string sqlconn) { context.Set<LacCellBvciStagingDocument>().Add(entity); return AddToContextCon(context, count, commitCount, recreateContext, sqlconn); }
public TcpDbContext AddToContext(TcpDbContext context, TcpPortSessionETLDocument entity, int count, int commitCount, bool recreateContext, string sqlconn) { context.Set<TcpPortSessionETLDocument>().Add(entity); return AddToContextCon(context, count, commitCount, recreateContext, sqlconn); }
public TcpDbContext AddToContext(TcpDbContext context, CalculationItem entity, int count, int commitCount, bool recreateContext, string sqlconn) { context.Set<CalculationItem>().Add(entity); return AddToContextCon(context, count, commitCount, recreateContext, sqlconn); }
public TcpDbContext AddToContext(TcpDbContext context, DimensionMessage entity, int count, int commitCount, bool recreateContext, string sqlconn) { context.Set<DimensionMessage>().Add(entity); return AddToContextCon(context, count, commitCount, recreateContext, sqlconn); }
//生成维度表和事实表,同时开启多个连接进行处理? public void saveTcpPortSessionETLDocumentSet(string sqlconn) { TcpDbContext[] context = new TcpDbContext[contextlen]; try { for (int i = 0; i < context.Length; i++) { context[i] = new TcpDbContext(sqlconn); context[i].Configuration.AutoDetectChangesEnabled = false; } int count = 0; TcpPortSessionETL trs = new TcpPortSessionETL(); foreach (var tcp in trs.mongo_TcpPortSessionETL.QueryMongo()) { ++count; Parallel.Invoke(() => { context[0] = context[0].AddToContext(context[0], tcp.DimIp, count, bulksize, true, sqlconn); context[1] = context[1].AddToContext(context[1], tcp.DimUdp, count, bulksize, true, sqlconn); context[2] = context[2].AddToContext(context[2], tcp.DimNs, count, bulksize, true, sqlconn); context[3] = context[3].AddToContext(context[3], tcp.DimBssgp, count, bulksize, true, sqlconn); context[4] = context[4].AddToContext(context[4], tcp.DimLlcSndcp, count, bulksize, true, sqlconn); context[5] = context[5].AddToContext(context[5], tcp.DimIp2, count, bulksize, true, sqlconn); context[6] = context[6].AddToContext(context[6], tcp.DimTcp, count, bulksize, true, sqlconn); context[7] = context[7].AddToContext(context[7], tcp.DimHttp, count, bulksize, true, sqlconn); context[8] = context[8].AddToContext(context[8], tcp.DimMessage, count, bulksize, true, sqlconn); context[9] = context[9].AddToContext(context[9], tcp.CalItem, count, bulksize, true, sqlconn); context[10] = context[10].AddToContext(context[10], tcp.FactTcp, count, bulksize, true, sqlconn); }); } for (int i = 0; i < context.Length; i++) context[i].SaveChanges(); } finally { for (int i = 0; i < context.Length; i++) if (context[i] != null) context[i].Dispose(); } Console.WriteLine("TcpPortSessionETLDocument->TcpDbContext->ok"); }