How to call and get result of scalar valued function using entity framework

Question

I am using Entity Framework 6.0.

I am having scalar valued function in SQL Server signatured as

fn_CartAmount(@CartId bigint) RETURNS decimal(18,2)

I want to call this function from Entity Framework and get its result.

Mark C. · Accepted Answer · 2016-04-25 15:10:49Z

3

You could try something like :

    public decimal GetCartAmount(int cartId)
    {

        var returnCode = new SqlParameter("@ReturnCode", SqlDbType.Bit) { Direction = ParameterDirection.Output };

        object[] parameters =
        {
            new SqlParameter(@"CartId", SqlDbType.BigInt) {Value = cartId}
            , returnCode
        };

        string command = string.Format("exec @ReturnCode = dbo.fn_CartAmount @CartId");
        Database.ExecuteSqlCommand(command, parameters);


        return (decimal)returnCode.Value;
    }

answered Apr 25, 2016 at 15:10

Mark C.

6,5004 gold badges39 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to call and get result of scalar valued function using entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related