SAP Business One:Coding with SDK and Blazor Visual Studio 22
What you'll learn
- Add the Business One SDK library to Visual Studio 2022
- Connection paramaters to Business One database
- Execute query and store results in a List type of objects
- Display the list of results in Razor client HTML table.
- Basic web programming with databases.
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.
Who this course is for:
- Developers of SAP Business One to present a next generation web applications using Razor.
Process and quality control using statistics. The data entry for data analysis is done with mobile software developed in house.
Expertise in Geographical Information Systems, Logistics and data acquisition with mobile and using Google Maps API.
Cross platform development for Android, Windows Mobile and Iphone with HTML5 and JSONP with webservices and Database on the Cloud (PHP, MYSQL).