Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Func<DataClassesDataContext, int, IQueryable<Product>> compiledQuery =
- CompiledQuery.Compile((DataClassesDataContext meta, int IdToFind) =>
- (from myData in meta.Products
- where myData.ProductID.Equals(IdToFind)
- select myData));
- StringBuilder Test = new StringBuilder();
- int[] MiaSeira = { 5, 6, 10, 100, 7 };
- using (DataClassesDataContext context = new DataClassesDataContext())
- {
- context.ObjectTrackingEnabled = false;
- for (int i = 0; i < 100; i++)
- {
- foreach (int EnaID in MiaSeira)
- {
- var oFindThat2P = compiledQuery(context, EnaID);
- foreach (Product One in oFindThat2P)
- {
- Test.Append("<br />");
- Test.Append(One.ProductName);
- }
- }
- }
- }
- StringBuilder Test = new StringBuilder();
- int[] MiaSeira = { 5, 6, 10, 100, 7 };
- for (int i = 0; i < 100; i++)
- {
- foreach (int EnaID in MiaSeira)
- {
- var Products = (from product in Product.
- where MiaSeira.Contains(product.ProductID)
- select product).ToList();
- if (Products == null || Products.Count == 0)
- continue;
- foreach (Product product in Products)
- {
- Test.Append("<br />");
- Test.Append(product.ProductName);
- }
- }
- }
- txtDebug.Text = Test.ToString();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement