Alternate to sql server table values parameter

tsakumar...

Kindly suggest alternatives to sql server table valued parameter as I am not able to add a stored procedure with table valued parameter in edmx file.

Dapper cannot be used as we did not get approval to use it.

dharmend...

0 7

Edmx does not support table valued parameters.

Table Valued Parameters are only supported in raw/inline SQL in Entity Framework.

So send Valued Parameters using SqlParameter to the ADO.NET provider.

Working sample already shared. Refer the following links.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Description

Description is required.