/// <summary> /// Query de busca de todos os conjuntos de json no banco de dados. /// </summary> public async Task <IEnumerable <object> > GetAllAsync() { var res = await _connection.QueryAsync <IEnumerable <JsonModel> >(@"SELECT r.json as ""RigthJson"", l.json as ""LeftJson"", l.id as ""IdLeft"", r.id as ""IdRight"" FROM public.rightdiff as r INNER JOIN public.leftdiff as l ON r.idleft = l.id "); return(res.ToList()); }