Investigate function mapping issue

[ErikEJ]

dotnet/efcore#27955

[ErikEJ]

@andrey-bulat I do not see a failing stored procedure in your sample reproduction !?

[ErikEJ]

I think TVP parameters with function mapping is not possible

[andrey-bulat]

@ErikEJ I updated https://github.com/andrey-bulat/EfCore6Test to show that in EF Core 3.1 TVP in SP work and doesn't work in 6.

Do you know is it supposed to fix it in version 7?

[ErikEJ]

How is it failing with EF Core 6. There should be no difference..

[andrey-bulat]

Yes, you are right - when I exclude UDF - it works, error in ValidateDbFunctions - here there is no mapping for TVP, I think that it just because of Udf parameters doesn't know how to map UDT:

In SP generated code contains:
new SqlParameter
{
ParameterName = "LabelIds",
Value = LabelIds ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Structured,
TypeName = "[dbo].[IntListType]",
},

In UDF there is no definition for TypeName

[andrey-bulat]

@ErikEJ do you know what could be workaround to define DataTable parameter mapping? some interceptors or wrappers?

[ErikEJ]

What error do you get with the stored procedure??

Full stacktrace pls

[ErikEJ]

Finding out is what this issue is about

[andrey-bulat]

when I exclude UDF, stored procedure works as expected, error is in ValidateDbFunctions

[ErikEJ]

OK, so there is no issue with stored procedures in EF Core 6, but the model is invalid due the use of a TVP in the Function mapping. Is that correctly understood?

[ErikEJ]

@ajcvickers Assume that using a TVP as parameter is simply not possible with an inline UDF ?

[ErikEJ]

dotnet/efcore#27954