How to call and execute a SQL Server function in Entity Framework?

Question

I have the following function in my SQL Server:

getMaxSL(paramter)

which will return a string value.

I have tried to call and execute this function from the Entity Framework in the following ways but did not work for me, instead it's returning the sql query itself.

var styleCode = (_dbContext as IObjectContextAdapter).ObjectContext.CreateQuery<string>("Select dbo.getMaxSL(500)");

and

var styleCode = _dbContext.Database.SqlQuery<string>("Select dbo.getMaxSL(500)");

Would anyone tell me what are the best possible ways to call and execute a SQL Server function in Entity Framework??

TanvirArjel · Accepted Answer · 2017-02-01 07:15:30Z

1

Finally I myself found the solution as expected:

The codes should be as follows:

var styleCodeID = (_dbContext as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery<string>("Select dbo.getMaxSL(500)").FirstOrDefault();

and

var styleCode = _dbContext.Database.SqlQuery<string>("Select dbo.getMaxSL(500)").FirstOrDefault();

answered Feb 1, 2017 at 7:15

TanvirArjel

32.4k14 gold badges88 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

How to call and execute a SQL Server function in 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