Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Enhance the self-cleanup for the new tests in the testlinq program. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | tkt-8d928c3e88 |
| Files: | files | file ages | folders |
| SHA1: | 6f6b1fe9d4ed8f211103ee553e5b6a2b |
| User & Date: | mistachkin 2015-01-13 02:28:27 |
Context
|
2015-01-13
| ||
| 03:18 | Simplify the new DateTime test in the testlinq program. check-in: 27511f2109 user: mistachkin tags: tkt-8d928c3e88 | |
| 02:28 | Enhance the self-cleanup for the new tests in the testlinq program. check-in: 6f6b1fe9d4 user: mistachkin tags: tkt-8d928c3e88 | |
| 02:20 | Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection. Add more tests. check-in: 2f3a593340 user: mistachkin tags: tkt-8d928c3e88 | |
Changes
Changes to testlinq/Program.cs.
572 573 574 575 576 577 578 579 580 581 582 583 584 585 ... 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 ... 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 |
ObjectQuery<string> query = db.CreateQuery<string>(sql);
foreach (string s in query)
Console.WriteLine(s);
}
return 0;
}
private static int DateTimeTest()
{
using (northwindEFEntities db = new northwindEFEntities())
{
................................................................................
}
}
private static void DateTimeTest2(
string dateTimeFormat
)
{
Trace.Listeners.Add(new ConsoleTraceListener());
Environment.SetEnvironmentVariable("SQLite_ForceLogPrepare", "1");
if (dateTimeFormat != null)
{
Environment.SetEnvironmentVariable(
"AppendManifestToken_SQLiteProviderManifest",
String.Format(";DateTimeFormat={0};", dateTimeFormat));
................................................................................
new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local)).Count();
DateTime dateTime = new DateTime(
1997, 1, 1, 0, 0, 0, DateTimeKind.Local);
db.Orders.Where(i => i.OrderDate < dateTime).Count();
}
Environment.SetEnvironmentVariable("SQLite_ForceLogPrepare", null);
}
private static int OldTests()
{
using (northwindEFEntities db = new northwindEFEntities())
{
{
|
> > > > > > | > > > > > > > > |
572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 ... 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 ... 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 |
ObjectQuery<string> query = db.CreateQuery<string>(sql);
foreach (string s in query)
Console.WriteLine(s);
}
Environment.SetEnvironmentVariable(
"AppendManifestToken_SQLiteProviderManifest",
null);
return 0;
}
private static int DateTimeTest()
{
using (northwindEFEntities db = new northwindEFEntities())
{
................................................................................
}
}
private static void DateTimeTest2(
string dateTimeFormat
)
{
TraceListener listener = new ConsoleTraceListener();
Trace.Listeners.Add(listener);
Environment.SetEnvironmentVariable("SQLite_ForceLogPrepare", "1");
if (dateTimeFormat != null)
{
Environment.SetEnvironmentVariable(
"AppendManifestToken_SQLiteProviderManifest",
String.Format(";DateTimeFormat={0};", dateTimeFormat));
................................................................................
new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local)).Count();
DateTime dateTime = new DateTime(
1997, 1, 1, 0, 0, 0, DateTimeKind.Local);
db.Orders.Where(i => i.OrderDate < dateTime).Count();
}
if (dateTimeFormat != null)
{
Environment.SetEnvironmentVariable(
"AppendManifestToken_SQLiteProviderManifest",
null);
}
Environment.SetEnvironmentVariable("SQLite_ForceLogPrepare", null);
Trace.Listeners.Remove(listener);
}
private static int OldTests()
{
using (northwindEFEntities db = new northwindEFEntities())
{
{
|