Entity Framework Core, UD sql function throws System.NotImplementedException: 'The method or operation is not implemented.'

Question

I am having a lot of trouble trying to run a SQL function from the DbContext, I have tried several suggestions with no luck.

I have a class library project, with Entity Framework Core (3.1.5). The project compiles and runs but when I try to run a unit test (before I deploy or integrate) every time I touch the function I get an error

System.NotImplementedException: 'The method or operation is not implemented.'

This is the SQL function:

CREATE FUNCTION [dbo].[GetLocalDate]()
RETURNS DATETIME
AS
BEGIN
     DECLARE @gd AS DATETIME =  getUTCdate()
     DECLARE @D AS datetimeoffset

     SET @D = CONVERT(datetimeoffset, @gd) AT TIME ZONE 'Central Standard Time'
     RETURN CONVERT(datetime, @D);
END

which is working in the database.

This is my database context:

public class VendorDbContext : DbContext
{
    public VendorDbContext(DbContextOptions options) : base(options)
    { }

    [DbFunction("GetLocalDate", "dbo")]
    public static DateTime GetLocalDate()
    {
        throw new NotImplementedException();
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.HasDbFunction(() => VendorDbContext.GetLocalDate());
    }
}

and this is the call in the class - Context is a local variable of the VendorDbContext type, and Vendor is an existing valid entity in the model:

var now = Context.Vendor.Where(v => v.CompanyId == 6)
                        .Select(v => VendorDbContext.GetLocalDate() ).FirstOrDefault();

Does not matter what I try, I always got the exception mentioned above.

Any ideas please?

When debugging I can reach the line in the function that throws the exception, so I am guessing is not properly mapped but I can tell why — Ax Perez Parra
– Ax Perez Parra, Commented Jul 30, 2020 at 23:21
So you're getting the exception when running a unit test? Are you mocking the DbContext or using an actual implementation? Also, do you get the exception when running the application normally? — devNull
– devNull, Commented Jul 30, 2020 at 23:42
Hi thanks so much for asking, the context is a EF empty context using (VendorDbContext context = new VendorDbContext(options)) and i havent run it normally, until unit testing complete i am not supposed to integrate this. — Ax Perez Parra
– Ax Perez Parra, Commented Jul 31, 2020 at 15:06
now with that question i think is important to add that the unit testing is in memory database — Ax Perez Parra
– Ax Perez Parra, Commented Jul 31, 2020 at 18:46
yeah I'm guessing that's the crux of the matter. It seems that the in-memory provider is rather limited functionality, so the DbFunction is likely just not executing as it would against a live database — devNull
– devNull, Commented Jul 31, 2020 at 23:05

Ramil Aliyev 007 · Accepted Answer · 2021-08-26 14:31:54Z

1

I faced same problem. I found reason of this problem for my code. If Entity Framework didn't execute LINQ query and occured local evalution, your DbFunction will execute in C# side. Therefore VendorDbContext.GetLocalDate() called in C# side will throw System.NotImplementedException

answered Aug 26, 2021 at 14:31

Ramil Aliyev 007

5,6102 gold badges38 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Core, UD sql function throws System.NotImplementedException: 'The method or operation is not implemented.'

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related