public User GetUserByUserName(string userName) { var query = @" select top 1 Id, Username, Email, PasswordHash from Users where Username = @username"; using (var conn = _dbConnectionProvider.GetOpenWsidnConnection()) { var user = conn.Query <User>(query, new { userName }); return(user.FirstOrDefault()); } }
public int CreateTask(CreateTask task) { using (var conn = _dbConnectionProvider.GetOpenWsidnConnection()) { var sql = @" insert into TasksToDo ([Description], IntervalByHour, UserID) values (@Description, @IntervalByHour, @UserId) select SCOPE_IDENTITY()"; var id = conn.ExecuteScalar <int>(sql, task); return(id); } }