Pauls Blog

So obvious I missed it,  Once connected, click the lock icon in the GUI, and the host info will pop up  

 A nice web based HTML editor to consider.  Froala - Looks good WYSIWYG HTML Editor | Rich Text Editor Online

AppDBContext _context = new (); var entityType = _context.Model.FindEntityType( typeof (ContractorProfession)); Console.WriteLine( "Entity: " + entityType.Name); Console.WriteLine( "Table: " + entityType.GetTableName()); Console.WriteLine( "Schema: " + entityType.GetSchema());

Sometimes, you want to concat a few fields together and have a separator, but you only want the separator when the next field is not empty and not blank ARRAY_CONSTRUCT creates an array from the fields ARRAY_COMPACT removes blanks and "undefined" ARRAY_TO_STRING converts the array to a single string, with a separator SELECT PERSONID , ARRAY_TO_STRING ( ARRAY_COMPACT ( ARRAY_CONSTRUCT ( NULLIF ( ADRLINE1 , '' ), NULLIF ( ADRLINE2 , '' ), NULLIF ( ADRLINE3 , '' ) ) ), ', ' ) AS ADDRESS FROM PERSONTABLE ;

  1) Click Data, Get Data, From Other Sources, Blank Query - You might be able to use "From Web", however Blank Query gives you more options  2)  Enter The Advanced Editor and Strucutre it as follows... let      Source = Json.Document(Web.Contents("https://localhost:7056/ap/endpoint" , [Headers = [Accept="application/json"]])),      TableFromRecords = Table.FromRecords(Source) in     TableFromRecords

<% ... %> – Code Block Executes C# code but does not render any output to the page. Useful for logic (e.g., declaring variables, loops). <% int x = 5; %> <%= ... %> – Output (Escaped) Evaluates the expression and writes the result to the page . The output is HTML-encoded (i.e., special characters are escaped). <%= "<b>Hello</b>" %> <!-- Outputs: &lt;b&gt;Hello&lt;/b&gt; --> In DevExpress, it actually outputs Hello, in bold 3. <%- ... %> – Output (Unescaped) Writes the result to the page without HTML encoding .