eBiss 3 en:howtos:dbadapter

A simple class structure

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

A simple class structure The following is an example of a Simple Class Structure for reading row from table: CREATE TABLE[dbo].[DbAdapterTest] ( [Id][int] NOT NULL, [LastName] [varchar] (50) NOT NULL, [FirstName] [varchar] (50) NOT NULL )

Database Connection String

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Database Connection String Once the class definition is completed, the following steps can be used to test the functionality of the newly created database connection in the eBiss system: * Import eBiss-Variables out of the local Dump into the eBiss

DB Adapter - mapping functions (ExecScalar)

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

DB Adapter - mapping functions (ExecScalar) For creating a mapping function that executes a DB operation inherit from eBiss.DbAdapter.Functions and use one of the following methods: * object ExecScalar(table, column, where-condition), * object ExecuteSqlScalar(sql statement) or

DB Adapter - variables

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

DB Adapter - variables Predefined variables * LastExecutionStartDate: Last start time from current job, * LastExecutionStartDateSerial: From LastExecutionStartDate the date formatted as Interger: yyyyMMdd, * LastExecutionStartTimeSerial: Formatted by LastExecutionStartDate the time as Interger: HHmm,

Preparation of source objects

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Preparation of source objects * Create a new project ( class library ) and add eBiss.DbAdapter.dll to References. * Create a new object that inherits from IMapObjectRoot . * Now add the required attributes as appropriate for your database shown below.

HowTo - database integration (DB adapter)

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

HowTo - database integration (DB adapter) The database adapter allows the direct integration of eBiss with a database. Access As a start, data from a simple and flat table 'DbAdapterTest' is to be read here. You define the necessary structure for reading the table 'DbAdapterTest' in dbadapter index

DB Adapter - Where Conditions

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

DB Adapter - Where Conditions A simple condition with a variable looks like this: [Where("< $State")] public int State; You can either define the variable in the default system partner using the prefix 'eBiss.DbAdapter.'; in this case: