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");
}