This course is in the next generation of web development using Visual Studio 2022 with Razor technology. Razor separates the development into the server and client tiers. The server C# code executes the query and stores results in a list type of objects. The client Razor HTML page loop thru this list to display the query results in table elements.

We will cover the addition of the Business One SDK library to the Visual Studio IDE. Explanation of the parameters to connect to the database. In this exercise, we are using a Hana-type database for Business One. B1 can use SQL server and Sybase as databases. Razor architecture requires storing the query database results in a list type of objects. This list is looping in the Razor HTML side to present the results in table elements with headings and details. Pass parameter to another Razor page to run another query with a dynamic value. In this example, we pass the document number of an invoice and account receivable from a client to get the payments done up to date.

It is important to keep in mind that the queries in B1 SDK must have an escape character of the apostrophes ("). That is because we have to specify the table name and the field name. The field name is enclosed in apostrophes.