C# (CSharp) ICustomersRepository.ExecStoreProcedure Examples

Example #1

        public List <Customers> GetCustomersBySP()
        {
            //exec [dbo].[CustOrderHist] @CustomerID = N'BOTTM'
            //dbContext.Set().FromSql("dbo.SomeSproc @Id = {0}, @Name = {1}", 45, "Ada");
            List <Customers> customers = _customersRepository.ExecStoreProcedure("exec [dbo].[MyTest] @Num = {0};", new object[] { 5 }).ToList();

            return(customers);
        }