System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Changes In Branch tkt-1a93312113 Excluding Merge-Ins

This is equivalent to a diff from 5df3f94594 to 2982a19b8e

2016-04-01
00:15
Merge updates from the 1.0.99 branch. check-in: 72134847ca user: mistachkin tags: trunk
2016-03-31
18:18
Add test case for ticket [1a93312113]. Closed-Leaf check-in: 2982a19b8e user: mistachkin tags: tkt-1a93312113
2016-03-30
21:03
Update the MSVCRT runtimes for VS 2015 in externals to 'Update 2', part 2. check-in: 5df3f94594 user: mistachkin tags: trunk
21:02
Update the MSVCRT runtimes for VS 2015 in externals to 'Update 2', part 1. check-in: f586f38b68 user: mistachkin tags: trunk

Changes to testlinq/Program.cs.

200
201
202
203
204
205
206






207
208
209
210
211
212
213
                      return RoundTest();
                  }
#endif
              case "complexprimarykey":
                  {
                      return ComplexPrimaryKeyTest();
                  }






              default:
                  {
                      Console.WriteLine("unknown test \"{0}\"", arg);
                      return 1;
                  }
          }
      }







>
>
>
>
>
>







200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
                      return RoundTest();
                  }
#endif
              case "complexprimarykey":
                  {
                      return ComplexPrimaryKeyTest();
                  }
#if NET_40 || NET_45 || NET_451 || NET_452 || NET_46 || NET_461
              case "any":
                  {
                      return AnyTest();
                  }
#endif
              default:
                  {
                      Console.WriteLine("unknown test \"{0}\"", arg);
                      return 1;
                  }
          }
      }
876
877
878
879
880
881
882


















883
884
885
886
887
888
889
              }

              Console.WriteLine("updated {0}", counts[1]);
          }

          return 0;
      }



















      private static int DateTimeTest()
      {
          using (northwindEFEntities db = new northwindEFEntities())
          {
              DateTime dateTime = new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local);
              int c1 = db.Orders.Where(i => i.OrderDate == new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local)).Count();







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
              }

              Console.WriteLine("updated {0}", counts[1]);
          }

          return 0;
      }

#if NET_40 || NET_45 || NET_451 || NET_452 || NET_46 || NET_461
      private static int AnyTest()
      {
          using (northwindEFEntities db = new northwindEFEntities())
          {
              List<long> orderIds1 = db.Orders.Select(x => x.OrderID).ToList();

              List<long> orderIds2 = db.OrderDetails.Select(
                  x => x.OrderID).Where(x => orderIds1.Any(y => y == x)).ToList();

              foreach (long id in orderIds2)
                  Console.WriteLine(id);
          }

          return 0;
      }
#endif

      private static int DateTimeTest()
      {
          using (northwindEFEntities db = new northwindEFEntities())
          {
              DateTime dateTime = new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local);
              int c1 = db.Orders.Where(i => i.OrderDate == new DateTime(1997, 1, 1, 0, 0, 0, DateTimeKind.Local)).Count();