How to execute stored procedure from a controller [duplicate]

Question

I have an existing stored procedure in my database. I also have an existing database context class as well (fragment code only).

Would you please help advise how do I call my stored procedure from my controller? What is the missing class or property in my model or DatabaseContext?

Thanks very much in advance

Sothun

CREATE PROCEDURE getEmployeeById

@employeeId nvarchar(7)

AS  SELECT * FROM employees WHERE id = @employeeId GO;



namespace Template.Models
{
    public class DatabaseContext : DbContext
    {
        public DatabaseContext() : base("dbConnectionString")
        {

        }
        public DbSet<Parameter> parameter { get; set; }
    //...
    }
}

Would point out that generally you probably wouldn't execute a stored procedure directly from a controller, as there would be some other layer in between the db and the controllers — Caius Jard
– Caius Jard, Commented Feb 10, 2021 at 8:26

Phạm Thế Hùng · Accepted Answer · 2021-02-10 09:32:12Z

0

In the implement controller you can do like that :

var context = new DatabaseContext(); 
var param = new SqlParameter("@employeeId", employeeId);
var parameters = context.parameter.FromSql("getEmployeeById @employeeId", param).ToList();

edited Feb 10, 2021 at 9:32

answered Feb 10, 2021 at 8:25

Phạm Thế Hùng

1651 silver badge6 bronze badges

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

3 Comments

Sothun Thay Over a year ago

Hello Pham, thanks for your comment. Where is this Students property is from? and how to define this property? Would you throw some more light here in my given DatabaseContext class above?

Phạm Thế Hùng Over a year ago

@SothunThay I have corrected the code.

Sothun Thay Over a year ago

Pham, thanks for answer so far. I understand that I would need to declare another property say public DbSet<Employee> employee { get; set; } in my DatabaseContext class. How my Employee class would look like then because the I want my store procedure to return true if record is found and false if no record is found

Collectives™ on Stack Overflow

How to execute stored procedure from a controller [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related