Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. Func<DataClassesDataContext, int, IQueryable<Product>> compiledQuery =
  2. CompiledQuery.Compile((DataClassesDataContext meta, int IdToFind) =>
  3. (from myData in meta.Products
  4. where myData.ProductID.Equals(IdToFind)
  5. select myData));
  6.  
  7. StringBuilder Test = new StringBuilder();
  8. int[] MiaSeira = { 5, 6, 10, 100, 7 };
  9.  
  10. using (DataClassesDataContext context = new DataClassesDataContext())
  11. {
  12. context.ObjectTrackingEnabled = false;
  13.  
  14. for (int i = 0; i < 100; i++)
  15. {
  16. foreach (int EnaID in MiaSeira)
  17. {
  18. var oFindThat2P = compiledQuery(context, EnaID);
  19.  
  20. foreach (Product One in oFindThat2P)
  21. {
  22. Test.Append("<br />");
  23. Test.Append(One.ProductName);
  24. }
  25. }
  26. }
  27. }
  28.  
  29. StringBuilder Test = new StringBuilder();
  30. int[] MiaSeira = { 5, 6, 10, 100, 7 };
  31. for (int i = 0; i < 100; i++)
  32. {
  33. foreach (int EnaID in MiaSeira)
  34. {
  35. var Products = (from product in Product.
  36. where MiaSeira.Contains(product.ProductID)
  37. select product).ToList();
  38.  
  39. if (Products == null || Products.Count == 0)
  40. continue;
  41.  
  42. foreach (Product product in Products)
  43. {
  44. Test.Append("<br />");
  45. Test.Append(product.ProductName);
  46. }
  47. }
  48. }
  49.  
  50. txtDebug.Text = Test.ToString();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement