EDK4Net 3.6.6

EDK4Net

Version 3.6.xxx

Introduction

EDK4Net is a framework designed to simplify the development of applications and libraries in c # / vb.net based on .NET Framework 4.7.2 or .NET Core 6.0

The main features of the framework are

• ORM (Object Relational Mapping)
• Proprietary query language (EDK4Net Query Language)
• Logging
• Auditing
• Caching
• Location
• Customized web controls for Asp.Net

Some of these features require the use of a database, which can be integrated into the source database or into a separate database.

ORM

Unlike other ORMs, EDK4Net does not generate simple objects that relate to a database. The generated objects (from now BusinessObject), in addition to the normal CRUD functions, have integrated other features such as data validation, write / read / execute permissions of properties and methods, creation of runtime properties, exclusive block of write access for single user.

The Framework uses a code generation tool (EDK4NetCodegen), which once set the connection to the Database, will allow to manage the generation of the code of the classes starting from the database tables.

It is possible to manage, within the same library, the connection to different databases, and perform transactional operations even on several databases simultaneously, thanks to the use of a connection manager called CNWrapper.

The CNWrapper is the tool that incorporates CRUD functionality.

EDK4Net Query Language

With this tool it will be possible to select data from the Database with a very simple query language, which directly uses the properties of the Business Objects. It is a language that uses TSQL terminology but structured as an expression, and is recognized by the Visual Studio intellisense. It supports queries made on BusinessObject residing in different databases (but on the same server), and allows dynamic queries to be made through the use of variables.

The selection of data can also take place through the creation of example BusinessObjects, which submitted to the CNWrapper, will act as queries to select the data that correspond to the example provided.

Logging

The integrated Logger allows, with a few lines of code, to write on file, or send by email, all the data necessary for debugging, auditing, exceptions stack and any other type of operation that requires file or email logging . The logger is completely configurable, both at runtime and through a configuration file.

Auditing

If required, all the Insert / Update / Delete operations in the database are saved in a separate audit database.

Each operation is accompanied by the following information:

• Modified date
• Username
• IP address and host name
• Unique ID of the transaction that made the change

The Insert and Delete operations will report all property values.

Update operations will report only the new values ​​of the changed properties.

The Audit engine can be configured at runtime, through a configuration file, and at the individual object level.

Caching

The integrated caching engine allows the saving of any type of object within the EDK4Net database, in order to be able to recover it later. In BusinessObjects this functionality is integrated, so that it is possible to save an object in the cache, for example in the case of a particularly large object, to reuse it without reloading it with a query from the main database where it resides.

The cache is automatically cleaned of too old saved objects, setting a life time in the application configuration file.

Localization

A resource manager for application localization is available, so as to natively integrate localization in applications developed with EDK4Net, without resorting to external components.

ASP.Net Web Control

For the development of classic Asp.Net applications, a customized System.Web.Page class (EDK4NetPage) is available, in which the databinding features for BusinessObjects have been integrated. Inheriting the pages from this class, it will be possible to use Asp.Net Custom Web Controls integrated in EDK4Net. These web controls integrate BusinessObject binding, formatting, and localization features and user or role level permissions for read / write access. Using these controls in Asp.Net pages it will not be necessary to generate input forms and reading pages as the same control will be used for reading and writing.