René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Selector not working","articleBody":"I'm using EFCoreRepository\r\n\r\nI tried selector with GetAll and FindAll, but it seems that it does not work. It always creates SQL query with all columns, instead of selector specific columns.\r\nEven simple example like this\r\n`var test = GetAll(x=\u003ex.Id)`\r\n\r\nor\r\n\r\n`var test = FindAll(selector: selector=\u003eselector.Id)`\r\n\r\nquery all columns, instead of just Id column value.\r\nLooks like selector is selecting from memory, and not from database. Is this true?\r\n\r\nHow can I make projections with SharpRepository so that my generated sql query contains only selected columns?\r\n\r\n\r\nDid I skip some configuration steps?\r\n\r\n## **EDIT**\r\n\r\nI did some investigation. It seems that this commit broke the functionality https://github.com/SharpRepository/SharpRepository/commit/c082ae65#diff-d24380b902ea13a619155432be3b7b18L289\r\nSelect is now IEnumerable, instead of IQueryable\r\n\r\nCurrent code\r\n![image](https://user-images.githubusercontent.com/350314/40393374-6c6bc74e-5e1f-11e8-8c30-0ce9b10f87f1.png)\r\n\r\nPreviuos code\r\n\r\n![image](https://user-images.githubusercontent.com/350314/40393487-eed4e2c4-5e1f-11e8-9d6b-cf58b995f8b0.png)\r\n\r\nWhy is this query Compiled?\r\nhttps://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/compiled-queries-linq-to-entities\r\n\r\nI think this should be used https://cmatskas.com/improve-ef-core-performance-with-compiled-queries/","author":{"url":"https://github.com/neman","@type":"Person","name":"neman"},"datePublished":"2018-05-22T14:42:22.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":16},"url":"https://github.com/207/SharpRepository/issues/207"}