Execute stored procedure using Entity Framework using LINQ

Question

I am getting

Incorrect syntax near 'ABC.Security.GetUserLocation'.

when executing a stored procedure with the following code.

. dots are the part of Name (for grouping), don't confuse it with Schema.

Something like "FirstName.LastName". I can execute it from SSMS without any problem.

var userNameToSearch = new SqlParameter("@userName", userName);
userNameToSearch.DbType = System.Data.DbType.String;
userNameToSearch.Size = 100;

List<Location> locations = db.Database.SqlQuery<Location>(@"[ABC.Security.GetUserLocation]", userNameToSearch).ToList();

return locations;

What would be the right way to use names like that from C# code ?

possible duplicate of How to call Stored Procedure in Entity Framework 6 (Code-First)? — laylarenee
– laylarenee, Commented Aug 3, 2015 at 20:42

Scharly Ochoa · Accepted Answer · 2015-08-03 20:37:14Z

1

Try to be explicit with your parameters

List<Location> locations = db.Database.SqlQuery<Location>(@"exec [ABC.Security.GetUserLocation] {0}", userNameToSearch).ToList();

"{0}" means that you are passing userNameToSearch as first parameter, doesnt matter whats the parameter's name.

answered Aug 3, 2015 at 20:37

Scharly Ochoa

3011 silver badge6 bronze badges

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

1 Comment

NSS Over a year ago

The first parameter need to be string value(or literal value) and not an SQLParameter at for SQL 2005 Version.

Community · Accepted Answer · 2017-05-23 12:23:53Z

1

You can call a stored procedure in your DbContext class as follows.

this.Database.SqlQuery<YourEntityType>("storedProcedureName",params);

here more information : https://msdn.microsoft.com/en-us/data/jj691402.aspx

this was an answer from this question : here

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Aug 3, 2015 at 20:28

Abiezer

7828 silver badges15 bronze badges

Collectives™ on Stack Overflow

Execute stored procedure using Entity Framework using LINQ

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related