Help retrieving columns from StoredProcedure using LINQ... RRS feed

  • Question

  • User-507786106 posted

    I need to retrieve data by using a stored Procedure using MVC LINQ.   I need to retrieve two fields from the table.

    My method is a public async Task IEnumerable and inside the body needs to return two columns from the stored procedure. There are no parameters for this stored procedure.  The goal is to return the two columns from the stored procedure.

    Columns: FullName, ClarkId

    Method - code

    public async Task<IEnumerable<ListClerks>> GetAllClerks()


       I need to be able to return list of clerks -- Please help


    Your expertise is greatly appreciated. Thank you.

    Tuesday, May 18, 2021 12:31 PM