Hi Johan,

Below is an example I use to retrieve data. Basically you pass in an SQL statement and paramters and it will return an IRecordsReader. If you don't care about compatibility with other datasources such as mysql you can use any database technique you like. It's just asp.net

Cheers,

Richard

  public List<ContentValidationErrorView> GetAll()
        {
            List<ContentValidationErrorView> validationErrors = new List<ContentValidationErrorView>();
            using (var reader = Application.SqlHelper.ExecuteReader("SELECT SEOAnalyzer_ValidationIssues.*,umbracoNode.Text AS DocumentTitle  FROM SEOAnalyzer_ValidationIssues INNER JOIN umbracoNode ON SEOAnalyzer_ValidationIssues.DocumentID = umbracoNode.id WHERE Ignore = 0 and ItemType='content' order by documentTitle, ValidationComponentAlias"))
            {
                while (reader.Read())
                {
                    validationErrors.Add(new ContentValidationErrorView(reader.GetInt("IssueId"))
                    {
                        DocumentID = reader.GetString("DocumentID"),
                        DocumentTitle = reader.GetString("DocumentTitle"),
                        Ignore = reader.GetBoolean("Ignore"),
                        IssueAlias = reader.GetString("IssueAlias"),
                        ValidationComponentAlias = reader.GetString("ValidationComponentAlias"),
                        Item = reader.GetString("Item"),
                        ItemText = reader.GetString("ItemText")
                    }
                    );
                }
            }
            return validationErrors;
        }