Entity Framework Code First Function [duplicate]

Question

I have an interesting problem with EF Code First and MSSQL user defined functions. I write a database function that returns a scalar value and I want to map that function to my DbContext.

Based on information that I found I wrote this:

[DbFunction("AppDbContext", "GetNextDocumentNumber")]
public virtual int GetNextDocumentNumber()
{
    return ((IObjectContextAdapter)this)
        .ObjectContext
        .ExecuteStoreCommand("GetNextDocumentNumber");
}

I also write a simple unit test to check if function returns correct values. The problem is that this code above returns -1. When I execute function on SMSS I get correct result.

After searching on the different sites I have found a solution thatlooks like this:

public virtual int GetNextDocumentNumber()
{
    return this.Database
         .SqlQuery<int>("select dbo.GetNextDocumentNumber()")
         .Single();
}

In this case i get the correct value.

I just want to know what is wrong with the previous code or what am I doing wrong. In both cases I get a value. But only in one case value is correct.

Mitat Koyuncu · Accepted Answer · 2017-08-23 14:01:51Z

0

This may provide an answer to what you need.

edited Aug 23, 2017 at 14:01

Mitat Koyuncu

9281 gold badge8 silver badges20 bronze badges

answered Jul 22, 2016 at 11:38

Peter Smith

5,5529 gold badges54 silver badges80 bronze badges

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

1 Comment

TomAsh Over a year ago

Thanks! Calling function in LINQ expression solved my problem.

Collectives™ on Stack Overflow

Entity Framework Code First Function [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related