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