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
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(); }
return (con.Query<Guid>("Usp_UserIDbyUserName", param, null, true, 0, CommandType.StoredProcedure).SingleOrDefault()).ToString();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)