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 void CreatCollection()
{
foshan_llc_dataEntities gb = new foshan_llc_dataEntities();
//GuangZhou_Gb_LLC_ReTransmission gb = new GuangZhou_Gb_LLC_ReTransmission();
//GuangZhou_Gb_TCP_ReTransmission gb = new GuangZhou_Gb_TCP_ReTransmission();
gb.CommandTimeout = 0;
gb.ContextOptions.LazyLoadingEnabled = true;
gb.Gb_LLC_ReTransmission.MergeOption = MergeOption.NoTracking;
var fc = from p in gb.Gb_LLC_ReTransmission
group p by new
{
p.bssgp_lac,
p.bssgp_ci,
p.nsip_bvci,
p.ip_src_host,
p.ip_dst_host,
} into ttt
select new
{
ttt.Key.bssgp_lac,
ttt.Key.bssgp_ci,
ttt.Key.nsip_bvci,
ttt.Key.ip_src_host,
ttt.Key.ip_dst_host,
cnt = ttt.Count(),
//msg = ttt.Select(e => e.LLC_MsgType).FirstOrDefault(),//.First(),
//callid = ttt.Select(e => e.BeginFrameNum).FirstOrDefault(),//.Distinct().First(),
/*
//http://stackoverflow.com/questions/1066760/problem-with-converting-int-to-string-in-linq-to-entities
callid = ttt.Select(e => SqlFunctions.StringConvert((double)e.BeginFileNum.Value).Trim()
+ "-" + SqlFunctions.StringConvert((double)e.BeginFrameNum.Value).Trim()).Distinct()
* */
};
foreach (var p in fc)
{
LacCellBvciStagingDocument lcbd = new LacCellBvciStagingDocument();
lcbd._id = GenerateId();
if (p.bssgp_lac != null)
lcbd.lac = p.bssgp_lac.ToString();
if (p.bssgp_lac != null && p.bssgp_ci != null)
lcbd.lac_cell = p.bssgp_lac.ToString() + "-" + p.bssgp_ci.ToString();
lcbd.src = p.ip_src_host;
lcbd.dst = p.ip_dst_host;
lcbd.bvci = p.nsip_bvci;
lcbd.cnt = p.cnt;
//lcbd.msg = p.msg;
//if (p.callid != null)
// lcbd.callid = p.callid.Value.ToString();
mongo_LacCellBvciStaging.MongoCol.Insert(lcbd);
}
//mongo_lac_cell_bvci.BulkMongo(bv.ToList(), true);
Console.WriteLine("LacCellBvciStagingDocument->mongo->ok");
//BulkMongo(bv.ToList());
}
