static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion var n = new PerformanceResourceTimingData2ApplicationPerformance(); n.Delete(); n.Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, connectEnd = 13, EventTime = DateTime.Now.AddDays(-0), z = new XElement("goo", "foo") } ); var ee = n.AsEnumerable(); var q = from x in new PerformanceResourceTimingData2ApplicationPerformance() //orderby x.Timestamp descending select new { x.z, x.Key, x.connectStart, x.connectEnd, x.Timestamp } into g select g; //select g.connectStart; //var f = q.FirstOrDefault(); // X:\jsc.svn\examples\javascript\forms\test\TestMinSelector\TestMinSelector\ApplicationControl.cs var f = q.Min(k => k.connectStart); //var f = q.Min(); Console.WriteLine(new { f }); }
static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion var n = new PerformanceResourceTimingData2ApplicationPerformance(); n.Delete(); new PerformanceResourceTimingData2ApplicationPerformance().Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, connectEnd = 13, EventTime = DateTime.Now.AddDays(-0), z = new XElement("goo", "foo") } ); new PerformanceResourceTimingData2ApplicationResourcePerformance().Insert( new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { // lookup connectStart = 5, duration = 77 }, new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { // lookup connectStart = 5, duration = 33 } ); var q = from x in new PerformanceResourceTimingData2ApplicationPerformance() let rminq = from y in new PerformanceResourceTimingData2ApplicationResourcePerformance() where y.connectStart == x.connectStart select y.duration let rmin = rminq.Min() select new { rmin }; var f = q.FirstOrDefault(); //var f = q.Min(); Console.WriteLine(new { f }); }
static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion var n = new PerformanceResourceTimingData2ApplicationPerformance(); n.Delete(); n.Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, connectEnd = 13, EventTime = DateTime.Now.AddDays(-0), z = new XElement("goo", "foo") } ); var ee =n.AsEnumerable(); var q = from x in new PerformanceResourceTimingData2ApplicationPerformance() //orderby x.Timestamp descending select new { x.z, x.Key, x.connectStart, x.connectEnd, x.Timestamp } into g select g; //select g.connectStart; //var f = q.FirstOrDefault(); // X:\jsc.svn\examples\javascript\forms\test\TestMinSelector\TestMinSelector\ApplicationControl.cs var f = q.Min(k => k.connectStart); //var f = q.Min(); Console.WriteLine(new { f }); }
static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion var n = new PerformanceResourceTimingData2ApplicationPerformance(); n.Delete(); new PerformanceResourceTimingData2ApplicationPerformance().Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, connectEnd = 13, EventTime = DateTime.Now.AddDays(-0), z = new XElement("goo", "foo") } ); new PerformanceResourceTimingData2ApplicationResourcePerformance().Insert( new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { // lookup connectStart = 5, duration = 77 }, new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { // lookup connectStart = 5, duration = 33 } ); var q = from x in new PerformanceResourceTimingData2ApplicationPerformance() let rminq = from y in new PerformanceResourceTimingData2ApplicationResourcePerformance() where y.connectStart == x.connectStart select y.duration let rmin = rminq.Min() select new { rmin }; var f = q.FirstOrDefault(); //var f = q.Min(); Console.WriteLine(new { f }); }