Making a SQL Call from a UI Model - connection string?

Rick Root
Rick Root
Tenth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud CRM Developer Discussions
How do I get a connection string from the UI Model?


This doesn't seem to work:


this.HostModel.GetRequestContext().AppDBConnectionString();


(I'm using C#, that's why it's "this" and not "Me")



 

Comments

  • Matt Hall
    Matt Hall
    Ninth Anniversary Kudos 1 Participant Facilitator 1
    Hi Rick--this should work (will return an opened DB connection, hence the using):



      using (IDbConnection conn = GetRequestContext().OpenAppDBConnection())
  • Rick Root
    Rick Root
    Tenth Anniversary Kudos 2 Name Dropper Participant

    Matt Hall:

    Hi Rick--this should work (will return an opened DB connection, hence the using):



      using (IDbConnection conn = GetRequestContext().OpenAppDBConnection())

    Thanks!


    I did figure out what part of my original code was wrong


    this.HostModel.GetRequestContext().AppDBConnectionString();


    So this also worked


    this.GetRequestContext().AppDBConnectionString();


    But I like your solution better.

Categories