C
C#•17mo ago
kopuo

❔ Calling extensions method in linq query

Hi, is there any way to use my own extension method in a linq to query? With the approach below, it throws me an exception about the method not being able to be translated to SQL. If I add ..AsEnumerable().Select(...).AsQueryable() will it be a correct solution? 
var productsQuery = _dbContext.Products.AsNoTracking().Select(p => new ProductModel
        {
            Name = p.Name,
            Quantity = p.Quantity.MyExtensionMethod(), // p.Quantity == null ? "None" : p.Quantity.ToString()
            Price = p.Price
        });
var productsQuery = _dbContext.Products.AsNoTracking().Select(p => new ProductModel
        {
            Name = p.Name,
            Quantity = p.Quantity.MyExtensionMethod(), // p.Quantity == null ? "None" : p.Quantity.ToString()
            Price = p.Price
        });
6 Replies
Denis
Denis•17mo ago
https://stackoverflow.com/questions/4867100/workarounds-for-using-custom-methods-extension-methods-in-linq-to-entities
Stack Overflow
Workarounds for using custom methods/extension methods in LINQ to E...
I have defined a GenericRepository class which does the db interaction.
protected GenericRepository rep = new GenericRepository(); And in my BLL classes, I can query the db like:
public Li...
Denis
Denis•17mo ago
this is what I found
Denis
Denis•17mo ago
https://www.section.io/engineering-education/adding-custom-methods-for-linq-queries/
Engineering Education (EngEd) Program | Section
Adding Custom Methods to LINQ Queries in C#
This article will explain how to add custom methods to LINQ queries and how to customize LINQ queries. We will develop an application that retrieves JSON data from an API, query the data using the LINQ queries.
Denis
Denis•17mo ago
https://subscription.packtpub.com/book/application-development/9781849688567/1/ch01lvl1sec16/extension-methods-on-iqueryable-(become-an-expert)
Packt
Extension methods on IQueryable (Become an expert) | Instant .NET 4...
IQueryable is used to operate mainly on databases. IQueryable are an extension from IEnumerable, hence, we can call all extensions and methods of IEnumera
Anton
Anton•17mo ago
no, converting to IEnumerable will evaluate that on the client. in your case it doesn't matter but in general, don't do that
Accord
Accord•17mo ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
❔ class not showing upthere's no option to add class from vistual studio where u normally add class. what should i do❔ Exception settings in visual studio codeIs there an extension/built in way to choose which exceptions i am breakpointing on while debugging ❔ Tower Defense Enemy MovementHaving a problem with line 37.... ``` 1 2 using UnityEngine; 3 4 [RequireComponent(typeof(Enemies)❔ Need Help```csharp using System; using System.Diagnostics; using System.IO.Ports; namespace ABRA_KEYBOARD_CT❔ EFCORE DESIGN ONE TO MANYCan you guys help me to design a correct one to many relationships in this case ### The problem I ❔ I need help with String splitSo is there a way if im splitting string to 3lines to remove the last string? Or is it possible to s❔ Allow service to interact with desktop```cs public const int KEYEVENTF_EXTENTEDKEY = 1; public const int KEYEVENTF_KEYUP = 0; ❔ AllOf<>? Something along the same lines as discriminated unions?Essentially I am trying to write a generic class that is something like this: ```cs public class ✅ use one string if a condition is true, else use another stringSorry if the title is unclear but is there something like python's ```py foo = "hello" if condition ❔ How to use a variable across an entire classI'm wanting to use the ``client`` var (at the end of Awake) in the Enter key case, so I can post a s