nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Rick Root

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")

Find more posts tagged with

Comments

Matt Hall

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

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

Rick Root

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.