Guest User

Untitled

a guest
Jun 19th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. //private member which holds a compiled query.
  2. Func<DataAccess.DataClasses1DataContext, List<int>, List<DataAccess.TestRecord>>
  3. compiledFiftyRecordQuery = System.Data.Linq.CompiledQuery.Compile
  4. <DataAccess.DataClasses1DataContext, List<int>, List<DataAccess.TestRecord>>
  5. ((dc, ids) => dc.TestRecords.Where(tr => ids.Contains(tr.ID)).ToList());
  6.  
  7. //this method calls the compiled query.
  8. public void FiftyRecordCompiledQueryByID()
  9. {
  10. List<int> IDs = GetRandomInts(50);
  11.  
  12. //System.NotSupportedException
  13. //{"Parameters cannot be sequences."}
  14.  
  15. List<DataAccess.TestRecord> results = compiledFiftyRecordQuery
  16. (myContext, IDs);
  17. }
Add Comment
Please, Sign In to add comment