How to get the value of unique identifier from SQL server 2012 stored procedure using name column in the same table

See more:

C#5.0

dapper

MVC5

I just require the value of unique identifier from SQL Server Stored Procedure i.e, user id from username..... Is it possible to get or not

Can anyone suggest me for this.....

What I have tried:

My SQL Query:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Usp_UserIDbyUserName] 
	@LoginName VARCHAR(15)
AS
BEGIN
	
	SELECT UsersID FROM Users WHERE UserName =@LoginName

END

and i am using dapper framework to retrieve the user id... The code as follows:

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyString"].ConnectionString))
            {
                var param = new DynamicParameters();
                param.Add("@LoginName", username);
                return con.Query<string>("Usp_UserIDbyUserName", param, null, true, 0, CommandType.StoredProcedure).SingleOrDefault();
            }