> Maybe it's somehow using LINQ-to-MSSQL instead? What does the C# code > look like that is actually performing the LINQ query?
That would make sense. I'm actually using the dynamic linq library. First I get a context then I perform select and take operations on it var dbConnection = new SQLiteConnection("Data Source=db;provider=System.Data.SQLite.Linq;"); var context = new DataContext(dbConnection); var table = context.GetTable<TableClass>(); // table is now an instance of IQueryable<TableClass> table.Select("new (it.columnName)").Take(20); Maybe I'm getting the context incorrectly? Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of NAVEX Global? Inc. and the intended recipients and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.