Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jan Egil Kristiansen 30 posts 151 karma points
    Jul 17, 2017 @ 15:57
    Jan Egil Kristiansen
    0

    Querying the SQL database?

    I'd like to run a query against the SQL database. Specifically, I want

    select max(updateDate) from cmsDocument

    As I understand it, I need an SqlConnection object to execute the query. I suppose Umbraco already has a connection, if I only can get hold of it?

    (Based on the assumption that this SQL query is faster than looping through all the documents. I hear something about documents being cached, so maybe not?)

  • Marcio Goularte 167 posts 517 karma points
    Jul 17, 2017 @ 17:31
    Marcio Goularte
    100

    You can use DatabaseContext that already has sqlconnection:

      var db = ApplicationContext.Current.DatabaseContext.Database;
       var result = db.Query<DateTime>("select max(updateDate) from cmsDocument");
    
  • Jan Egil Kristiansen 30 posts 151 karma points
    Jul 17, 2017 @ 22:33
    Jan Egil Kristiansen
    0

    And for ignorants like myself, I have to add

    modificationStamp = result.ElementAt<DateTime>(0);
    
  • Jan Egil Kristiansen 30 posts 151 karma points
    Jul 17, 2017 @ 21:18
    Jan Egil Kristiansen
    0

    I got it working with

    umbraco.DataLayer.IRecordsReader reader;
    reader = umbraco.BusinessLogic.Application.SqlHelper.
        ExecuteReader("select max(updateDate) as modified from cmsDocument");
    reader.Read();
    modificationStamp = reader.GetDateTime("modified") ;
    

    My reader is an Umbraco object, while Marcio's result is I think a C# object? The latter is more tempting to me.

    I didn't find documentation for neither object, but I suppose Visual studio will help me out with Query objects, too.

  • Marcio Goularte 167 posts 517 karma points
    Jul 17, 2017 @ 21:58
    Marcio Goularte
    0

    What version of umbraco are you using? This code is using legacy api. I've never used it that way.

  • Jan Egil Kristiansen 30 posts 151 karma points
    Jul 17, 2017 @ 22:24
    Jan Egil Kristiansen
    0

    7.1.8

Please Sign in or register to post replies

Write your reply to:

Draft