System.Data.SQLite

Check-in [2982a19b8e]
Login

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

Overview
Comment:Add test case for ticket [1a93312113].
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | tkt-1a93312113
Files: files | file ages | folders
SHA1: 2982a19b8e9019e38552daed883ebabf9c7ded56
User & Date: mistachkin 2016-03-31 18:18:13.190
Context
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
Changes
Unified Diff Ignore Whitespace Patch
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();