Sap Business One:Coding With Sdk And Blazor Visual Studio 22
Published 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 822.90 MB | Duration: 1h 29m

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.
Requirements
Basic web programming with databases.
Description
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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Business One SDK connection to the database

Lecture 2 Connection parameters and use of SDK library in the Visual Stutio 2022 IDE

Section 3: Define List variable to store columns values from the database query results

Lecture 3 Class with resultset columns and add into a List of objects

Section 4: Query execution

Lecture 4 Resultset to execute the query to the database. Get the accounts receivables.

Section 5: Display the results from the database in the HTML page

Lecture 5 HTML page to display the query results.

Section 6: Pass a GET parameter to another Razor page

Lecture 6 Passing parameters to another razor page

Section 7: Conclusions

Lecture 7 Review of client and server code execution in Razor

Developers of SAP Business One to present a next generation web applications using Razor.

https://www.udemy.com/course/sap-business-one-coding-with-sdk-blazor-visual-studio-22/