I have TBV function . Like this
ALTER FUNCTION [dbo].[fn_Functiont] ( @accessibleIds ListAccesableIds READONLY ) RETURNS TABLE AS RETURN ( SELECT d.*, b.Name AS Name, ps.Name AS PaymentSystemName, c.UserName AS UserName, c.FirstName AS ClientFirstName, c.LastName AS LastName, c.Number AS DocumentNumber, c.Id FROM Document AS d JOIN System AS ps ON d.SystemId = ps.Id JOIN Client AS c ON c.Id = d.ClientId LEFT JOIN Shop AS b ON b.Id = d.ShopId WHERE d.OperationTypeId IN (2, 4, 5) AND c.Type = 1 )
I want to pass to this function List containing integers.I was bale to create table valued type but here is the question how could i pass List input parameter to the function?I know that i could pass lists via ADO.Net to the SP very easly but my problem regards to the Entity Framework and TBF functions
I am calling this function through Entity Framework 6 the approach which we used was database first.