This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, This linq query: var test = from o in uow.Contents where o.Id == 2 select new { Name = o.Title }; Results in this: exec sp_executesql N'SELECT Which is perfect. However, this LINQ query: var test2 = from o in uow.Contents Results in this: exec sp_executesql N'SELECT Basically, it pulls in all fields from both tables. Can this be optimized like the first one? John |
|
|
Hi John, No not currently, however this is something we have on our backlog to be improved in the future.
Jeremy |
|
|
Thanks for the speedy reply; Thats a shame though - kind of a deal breaker for me. Hopefully it will get fixed soon. John |
|
|
Just out of curiosity, do you have any kind of ETA on this? If its soon, I might be able to wait.
Thanks, John |
|
|
Hi John, Currently we dont any specific ETA on this, so unfortunately I cant promise anything. Happy to update you once this changes however.
Jeremy |
|