ajcvickers
commented
6 months ago Full repro below:
using (var context = new SomeDbContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Add(new Foo());
context.SaveChanges();
context.Database.ExecuteSqlRaw(
"""
CREATE FUNCTION dbo.Test(@i int) RETURNS int AS
begin
return @i;
end
"""
);
}
using (var context = new SomeDbContext())
{
Console.WriteLine(context.Set<Foo>().Select(e => context.Test(e.Id)).FirstOrDefault());
}
using (var context = new SomeDbContext())
{
WithInterface(context, context);
}
void WithInterface(SomeDbContext context1, IMyDbContext context2)
{
Console.WriteLine(context1.Foos.Select(e => context2.Test(e.Id)).FirstOrDefault());
}
public class SomeDbContext : DbContext, IMyDbContext
{
public DbSet<Foo> Foos => Set<Foo>();
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder
.UseSqlServer(@"Data Source=localhost;Database=One;Integrated Security=True;Trust Server Certificate=True")
.LogTo(Console.WriteLine, LogLevel.Information)
.EnableSensitiveDataLogging();
[DbFunction("Test", "dbo", IsBuiltIn = false)]
public int Test(int i) => throw new NotSupportedException();
}
public class Foo
{
public int Id { get; set; }
}
public interface IMyDbContext
{
int Test(int i);
}
chris-pie
DbFunction don't get the mapping function when an interface is used
There's a strange behavior when an interface is used instead of the direct object of dbcontext when a DbFunciton is called. In the code bellow, I create a function in sql (Test) and added it to my context using DbFunctionAttribute.
If MyDbContext is used to call the Test function works ok. The problem is when the IMyDbContext interface is required to the dependency injection, the Test function throws the NotSupportedException like the mapping doesn't exist.
I tried to cast the interface reference to the base class and works ok, but I believe it's not the desired behavior using interfaces. Also, I tried to add virtual to Test function in MyDbContext, but didn't works with the interface.
Code
Stack traces
Include provider and version information
EF Core version: Microsoft.EntityFrameworkCore, 8.0.0 Database provider: Microsoft.EntityFrameworkCore.SqlServer, 8.0.0 Target framework: net8.0 Operating system: Windows 10 IDE: Microsoft Visual Studio Professional 2022 (64-bit) 17.8.3