Entity Framework 6 - Knowledge Base (KB)

Table Valued Function and Entity Framework

I'm trying to execute an TVF with Entity Framework and for some reason it just doesn't work. Maybe anyone out there can help me see the problem....Here are the code samples:...That's the function:...CREATE FUNCTION [dbo].[udf_profileSearch] (@keywords NVA...

access a Database scalar value function in Entity framework 6 within linq

What steps i should follow to use the following sql scalar value function within entity framework....select dbo.GetDefaultAccount(5,1,48) ...I tried creating a static class under the same namespace of the edmx and defining the function as following... ...

How to map Table Valued Functions in EF6 Code First with different column names?

It is possible to map a table valued functions in EF6 without edmx? The problem is that the columns in the database are named differently than in the application....My application as a simplified example....Database...The table ...user... on SQL Server 20...

How to map user defined table valued function to EF 6 database first entity collection?

I am trying to solve a problem with mapping original entity on UDF execution. I have this scenario:... CREATE FUNCTION [dbo].[GetUsers] ( @password nvarchar(50) NULL ) RETURNS TABLE AS RETURN ( SELECT UserID, User...

Call SQL Server UDF in LINQ query

I have this UDF in SQL Server: [dbo].[ObtieneEdad]...This definition in EDMX file:...<Function Name="ObtieneEdad" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" R...