Performing SQL queries

To execute SQL queries we use the method ExecuteQuery<T>(string query, SqlParameters[] parameters).

Example:

using (var ctx = new AppContext(new AppConfiguration()))
{
    var query = ctx.ExecuteQuery<string>(
        "SELECT Column_Name FROM MYDB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @param",
        new SqlParameter("@param", "tbDbVersion"));

    dbVersion = query.FirstOrDefault();
}