Timeline for Producing queries based on user interface selection
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 15, 2015 at 19:22 | history | edited | Jamal | CC BY-SA 3.0 |
deleted 43 characters in body; edited title
|
| Jul 26, 2012 at 4:36 | history | tweeted | twitter.com/#!/StackCodeReview/status/228348026878562304 | ||
| Jul 25, 2012 at 21:30 | history | migrated | from stackoverflow.com (revisions) | ||
| Jul 25, 2012 at 20:06 | answer | added | PCasagrande | timeline score: 3 | |
| Jul 25, 2012 at 19:54 | comment | added | Patrick McCurley | Thanks for the suggestion Maarten, I tried that and it produced the same statement. In a bizarre progression though if I change the datetime operator to '<=' instead of the intended '>=' it takes 2s, and returns 11k rows.. the original >= is 300 rows over 6 minutes. The db is SQL2000. ideas? (updated post too) | |
| Jul 25, 2012 at 18:33 | comment | added | Maarten | What happens if you construct the linq query manually (without using DLINQ), what SQL is generated? Does that query perform? If so, then it's the translation of the string value to the expression. Not sure how to improve this though :-( | |
| Jul 25, 2012 at 17:57 | comment | added | Patrick McCurley | The LINQ query is generated using the dynamic linq library in a generic context. Therefore the line is : DataContext.CreateObjectSet<T>().AsQueryable().Where<T>(queryString, paramArray); The ORM is Entity Framework. Beta 5.0 | |
| Jul 25, 2012 at 17:18 | comment | added | Jim Counts | Can you clarify what ORM you are using? More than one uses LINQ. Is this entity framework? | |
| Jul 25, 2012 at 17:07 | comment | added | Jeff Mercado | How do you actually generate the LINQ query? | |
| Jul 25, 2012 at 16:59 | history | asked | Patrick McCurley | CC BY-SA 3.0 |