Use C# Caller Member Name as a Logger

ActivityLog.cs

/*
CREATE PROCEDURE [dbo].[ADD_ACTIVITY_LOG] 
	-- Add the parameters for the stored procedure here
	@activityDate datetime, 
	@activityDesc nvarchar(100),
	@activityDetail nvarchar(MAX)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	INSERT INTO [dbo].[ACTIVITY_LOG]
			   ([ACTIVITY_DATE]
			   ,[ACTIVITY_DESC]
			   ,[ACTIVITY_DETAIL])
		 VALUES
			   (@activityDate
			   ,@activityDesc
			   ,@activityDetail)
END
*/


        public static void AddActivityLog(string detail,
            [System.Runtime.CompilerServices.CallerMemberName] string memberName = "")
        {
            using (var conn = Util.GetConnection())
            {
                conn.Query("ADD_ACTIVITY_LOG", new { activityDate = DateTime.Now, activityDesc = memberName, activityDetail = detail }, commandType: CommandType.StoredProcedure);
            }
        }