public Alias GetAlias(string name, long sessionId) { if (_keywordService.IsReserved(name)) { return(Alias.Reserved(name)); } var sql = @" select n.Name as Name, s.id as Id, s.id_session as IdSession, s.arguments as Arguments, s.file_name as FileName, s.notes as Notes, s.run_as as RunAs, s.start_mode as StartMode, s.working_dir as WorkingDirectory from alias s inner join alias_name n on s.id = n.id_alias where lower(n.name) = lower(@name) and s.id_session = @sessionId"; using (var c = BuildConnection()) { var result = c.Query <Alias>(sql, new { name, sessionId }) .FirstOrDefault(); return(result ?? Alias.Empty(name)); } }