Service class example w/ Dapper usage for SProcs.

gistfile1.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text.RegularExpressions;
using Dapper;
...

namespace Services {
    
    public class UserService : IUserService
    {
        /// <summary>
        /// Retrieve all of the users within some kind of constraint.
        /// </summary>
        /// <param name="exampleParameter">A parameter that will be passed into the sproc.</param>
        /// <returns>List of users</returns>
        public IEnumerable<User> GetUsers(int exampleParameter) 
        {
            return Current.DB.Query<User>("sp_GetUsers", new {
                @v_ParameterName = exampleParameter
            }, commandType: CommandType.StoredProcedure);
        }

        /// <summary>
        /// Check if user exists.
        /// </summary>
        /// <param name="username"></param>
        /// <param name="organizationId"></param>
        /// <returns>True if user exists, otherwise false</returns>
        public bool UserExists(string username, int organizationId) {
            var p = new DynamicParameters();
            p.Add("@v_UserName", username);
            p.Add("@v_OrganizationId", organizationId);
            p.Add("@o_Exists", null, DbType.Boolean, ParameterDirection.Output);

            Current.DB.Execute("sp_DoesUserExist", p, CommandType.StoredProcedure);
            
            return p.Get<Boolean>("@o_Exists");
        }
    }
}