CreateFunction Like

SUAT SUPHI 61 Reputation points


I need an example about CreateFunction for like

Could you give me an example ?

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
710 questions
A set of technologies in the .NET Framework for building web applications and XML web services.
4,279 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Bruce ( 59,036 Reputation points
        (string a, string b)  => a == b);

  2. Jack J Jun 24,476 Reputation points Microsoft Vendor

    @SUAT SUPHI, Welcome to Microsoft Q&A, if you want to make the function to replace string.

    You could try the following code.

       _connection.CreateFunction("likeit",(string x,string y)=> y, isDeterministic: true);

    Then, you could call it in the commandtext like the following:

        string sql = "select * from Posts where Title==likeit('i','h')";

    The result is equal to

    select * from Posts where Title='h'.

    Note: I suggest that you don't use the like keyword in the sql because it already has some definitions.

    Hope my solution could help you.

    Best Regards,


    If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our [documentation][3] to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments