This topic describes how to work with data through entity objects from Business Foundation (BF).
Note: This is the recommended way to work with BF because it is a highly extensible and easy-to-use framework, relying on the SQL API. See Working with SQLRecords for other options for working with data.
Classes in this topic are available in the Mediachase.BusinessFoundation.Data.Business and Mediachase.BusinessFoundation.Data namespaces.
In this topic
- DataContext initialization
- EntityObject class
- BusinessManager class
- Request-response system
- Typed entity objects
- MetaObject class
BF includes a request-response system to process entity object methods. You can create a request passing the target entity object and request parameters, and call the Execute method. BF finds the handler to process the request, calls the handler, and returns a response with the execution result.
The DataContext class has the User and UserTimeZone properties. Entity objects and modules can use them to provide programmatic access to the current user ID and time zone. You should initialize the User and UserTimeZone properties before working with entity objects.
When you create DateTime or Date meta-fields, you can pass the UserTimeZone and DateTime values, which are automatically converted to user time zone.
Tip: In an ASP.NET application, initialize DataContext in the Global.Application_BeginRequest method.
The EntityObject class represents a meta-class object. Meta-class is an abstract representation of something, whereas an entity object is a usable example of the item the meta-class represents.
An entity object can be typed or untyped. Use the EntityObject object and its properties to retrieve and update the entity object in the persistent storage. You cannot create a new EntityObject directly. Instead, use the BusinessManager class and request-response system for calling the Entity object methods.
The BusinessManager class represents methods for processing the request-response for entity objects. Call the BusinessManager static methods to initialize an entity object, and to create, update, delete, list and execute custom method for entity objects.
EntityObject page = BusinessManager.InitializeEntity("Class_1"); page["Title"] = "Title Text"; page["Description"] = "Description Text"; PrimaryKeyId pageId = BusinessManager.Create(page);
Use the request-response system to process entity object methods.
LoadRequest request = new LoadRequest(new EntityObject(metaClassName, primaryKeyId)); LoadResponse response = (LoadResponse)BusinessManager.Execute(request); EntityObject entityObject = response.EntityObject;
You can override the default method handler, add custom plug-ins, or define a custom method.
When an instance of a request is created and you call the BusinessManager.Execute method, BusinessManager creates a pipeline and the BusinessManager class executes the following events while the request is processed:
- Call the PreExecute method of the appropriate IRequestHandler class for the request.
- Call the Execute method of the appropriate IPlugin classes that are subscribed to from the PreMainOperation event.
- Open Transaction.
- Call the PreExecuteInsideTransaction method of the appropriate IRequestHandler class for the request.
- Call the Execute method of the appropriate IPlugin classes that are subscribed to from the PreMainOperation (In-Tranasaction) event.
- Call the Execute method of the appropriate IRequestHandler class for the request.
- Call the PostExecuteInsideTransaction method of the appropriate IRequestHandler class for the request.
- Call the Execute method of the appropriate IPlugin classes that are subscribed to from the PostMainOperation (In-Tranasaction) event.
- Commit the Transaction.
- Call the PostExecute method of the appropriate IRequestHandler class for the request.
- Call the Execute method of the appropriate IPlugin classes that are subscribed to from the PostMainOperation event.
A request handler is the process (frequently referred to as the endpoint) that runs in response to a request made to a business manager. The most common handler is a default entity object handler that processes default methods. When users execute methods, the request is processed by the business manager through the handler. You can create your own handler that executes custom methods.
To create a custom handler, create a class that implements the IRequestHandler interface. You should also implement the PreExecute, PreExecuteInsideTransaction, Execute, PostExecuteInsideTransaction, PostExecute methods.
BF has BaseRequestHandler helper class that you can use as a base class for a custom handler, and which implements the IRequestHandler together with virtual methods.
After you create a custom handler class, it must be registered in the Application config file, enabling the application to call the handler. In the config file of the application, create a mediachase.businessFoundation.data/businessManager section.
The following example shows how to register a handler that responds to requests for the Test method for Class_1 meta-class. The handler is defined as the SampleHandler class in the SampleHandlerAssembly assembly.
<businessManager> <plugins> <add metaClass="*" method="Update;Create" eventStage="PreMainOperationInsideTranasaction" type="SampleHandler, SampleHandlerAssembly" /> </plugins> </businessManager>
Note: Method attributes support a search mask with * and ? chars and multiple methods separated by semicolons. eventStage supports several event stage items separated by a vertical bar ( | ).
Business Foundation implements the following methods.
Example: Call the Initialize method to create a new instance of entity object.
InitializeEntityResponse response = (InitializeEntityResponse)BusinessManager.Execute(new InitializeEntityRequest(metaClassName)); EntityObject obj = response.EntityObject;
Example: Call the Load method to load an instance of entity object by primary key.
LoadResponse response = (LoadResponse)BusinessManager.Execute(new LoadRequest(new EntityObject(metaClassName, primaryKeyId))); EntityObject obj = response.EntityObject;
Example: Call the Create method to store an entity object in the persistent storage.
CreateResponse response = (CreateResponse)BusinessManager.Execute(new CreateRequest(target)); PrimaryKeyId newPk = response.PrimaryKeyId;
Example: Call the Update method to update an entity object in the persistent storage.
Example: Call the Delete method to delete an entity object from the persistent storage.
Example: Call the List method to select a collection of entity objects from the persistent storage.
ListResponse response = (ListResponse)BusinessManager.Execute(new ListRequest(metaClassName, filters, sorting)); EntityObject objs = response.EntityObjects;
To create a custom method, create and register a custom handler and define a custom request and response. Requests should be inherited from the Request class, and responses should be inherited from the Response class.
Filtration and sorting
Call the List method to return an array of entity objects from the meta-class. See the Filtering and Sorting section for information about FilterElement and SortingElement.
Entity objects used in your applications can be either typed or untyped. However, BF has other tools to support typed entity objects, with which programming is easier and less error-prone.
To use typed entity objects:
- Run McCodeGen to create typed entity object C# class.
- Register a new typed object as primary type for meta-class.
The McCodeGen application reads the mcgen file, extracts the meta-model, and generates a template and an output text file.
The meta model file
The output file
Using mcgen file to create a typed entity object
The McCodeGen application can generate C# classes from the mcgen file. A typed entity object class is very similar to the EntityObject untyped class, but includes properties mapped to column values and column name constant string.
The mcgen file should include this:
<?xml version="1.0" encoding="utf-8" ?> <mcgen xmlns="mediachase.codegen.config" extension="cs" template="Templates\BusinessFoundationEntityObject.aspx"> <EntityObject> <ConnectionString> Data Source=(local);Initial Catalog=TestDB;User ID=sa;Password=; </ConnectionString> <MetaClass>Book</MetaClass> <Params> <add key="Namespace" value="Test.MetaClass"/> </Params> </EntityObject> </mcgen>
The connection string
The name of meta-class
The typed row C# class namespace
Paste your connection string and meta-class name, declare an output class namespace, then execute McCodeGen from the command line.
McCodeGen.exe -mcgen:BookEntity.mcgen -out:BookEntity.cs
Then you can add a typed entity object class to your .NET project.
Typed entity object registration
After you create a typed entity object, register it in the application. Create a new handler based on EntityObjectDefaultRequestHandler and override the CreateEntityObject method, which creates and returns a typed entity object. After you create a handler, register it.
Note: BF allows for executing entity object methods through Web Service.
Visual Studio integration
Note: For Visual Studio integration to work, McCodeGen should be installed.
You can integrate the McCodeGen application with Visual Studio by adding the mcgen file to a Visual Studio project.
Check the properties for your mcgen file (in this case a CategoryRow.mcgen), the Custom Tool field should be blank. Enter the name McCodeGenerator.
The tool runs automatically. Check to make sure that the output was created by opening the Solution Explorer.
The MetaObject class allows low-level access to entity object persistent storage. The default handler uses MetaObject to load and save entity objects to a persistent storage. You can use MetaObject to call, get, update or delete low-level methods.
// Add MetaObject Extension metaClass.Extensions.Add(new MetaObjectExtensionInfo(HistoryManager.ModuleName, AssemblyUtil.GetTypeString(typeof (HistoryExtension)), MetaObjectExtensionActivationType.OnSave));
The MetaObject extension allows for capturing meta-object events, and the MetaObject extension is registered in the meta-class.
To create a custom MetaObject extension, first create a class that implements the IMetaObjectExtension interface. You should also implement the Init, PreSave, Save, PreDelete, Delete and Clone methods. Use the BaseMetaObjectExtension class as a base class for your extension.
After you create a custom extension class, register it in the MetaClass. Add the MetaObjectExtensionInfo object to the MetaClass.Extensions collection, passing extension name, extension type and activation type. This enables the extension to receive metaobject events.
Example: Add metaobject extension
//Add MetaObject Extension metaClass.Extensions.Add(new MetaObjectExtensionInfo(HistoryManager.ModuleName, AssemblyUtil.GetTypeString(typeof (HistoryExtension)), MetaObjectExtensionActivationType.OnSave));
Note: You can modify a meta-model only in Design mode. See the MetaClassManager Class section.
Extension supports several activation types:
- ByRequest(default). The extension is loaded on any meta object event.
- OnSave. The extension is loaded on save event.
- OnLoad. The extension is loaded on load meta object event.
Activation types enable you to optimize application performance.
A trigger is procedural code that is automatically executed in response to certain events on a particular meta-object in a persistent storage. The trigger is used mostly for keeping the integrity of the information on the persistent storage. If you have an employee meta-class, when a new meta-object is added to the employee's meta-class, a new meta-object should also be created in the meta-class of the taxes, vacations, and salaries.
- Call AddTrigger of the TriggerManager class to add a custom trigger.
- Call RemoveTrigger of the TriggerManager class to remove a custom trigger.
A trigger can be registered on create, update, and delete events for the meta-object.
Last updated: Oct 24, 2016