public void Log(string msg) { EFTracingProviderConfiguration.RegisterProvider(); EFCachingProviderConfiguration.RegisterProvider(); EFTracingProviderConfiguration.LogToConsole = false; TextWriter logFile = File.CreateText("SqlExcuteLog.txt"); ExtendedGuangZhou_GbEntities gz_gb_ex = new ExtendedGuangZhou_GbEntities(); gz_gb_ex.Log = logFile; }
private DataTable viewTableDetail_gb() { EFTracingProviderConfiguration.RegisterProvider(); EFCachingProviderConfiguration.RegisterProvider(); EFTracingProviderConfiguration.LogToConsole = false; TextWriter logFile = File.CreateText("SqlExcuteLog.txt"); ExtendedGuangZhou_GbEntities gz_gb_ex = new ExtendedGuangZhou_GbEntities(); gz_gb_ex.Log = logFile; var cnt_t = gz_gb_ex.Gb_FlowControlx.Count(); var size_t = gz_gb_ex.Gb_FlowControlx.Sum(e => e.ip_len); var gngi = from p in gz_gb_ex.Gb_FlowControlx group p by p.Flow_Control_MsgType into ttt select new { ttt.Key, cnt = ttt.Count(), cnt_total = cnt_t, cnt_percent = 1.0 * ttt.Count() / cnt_t, size = ttt.Sum(e => e.ip_len), size_total = size_t, size_percent = 1.0 * ttt.Sum(e => e.ip_len) / size_t, }; var dborder = gngi.OrderByDescending(e => e.cnt).ToList(); return dborder.ToDataTable(); }