Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
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 on how to work with data.
Classes in this topic are available in the Mediachase.BusinessFoundation.Data.Business and Mediachase.BusinessFoundation.Data namespaces.
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 user time zone 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.
Example: Creation of a new entity object
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.
Example: Load entity object
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 following events are executed by the BusinessManager class while the request is processed:
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, you 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 class SampleHandler in the assembly SampleHandlerAssembly.
Example: Register a plugin
<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.
BusinessManager.Execute(new UpdateRequest(target));
Example: Call the Delete method to delete an entity object from the persistent storage.
BusinessManager.Execute(new DeleteRequest(target));
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.
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 that are 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:
The McCodeGen application reads the mcgen file, extracts the meta-model, and generates a template and an output text file.
McCodeGen.exe-mcgen:mcgenFile-out:outputFile
Parameter | Description |
---|---|
mcgenFile |
The meta model file |
outputFile |
The output file |
The McCodeGen application can generate C# classes from the mcgen file. A typed entity object class is very similar to the untyped class EntityObject, 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>
Parameter | Description |
---|---|
ConnectionString |
The connection string |
MetaClass |
The name of meta-class |
Namespace |
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.
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.
Note: McCodeGen should be installed in order for the Visual Studio integration to work.
You can integrate the McCodeGen application with Visual Studio by adding the mcgen file to aVisual 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, you 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:
The use of activation type makes it possible 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.
A trigger can be registered on create, update, and delete events for the meta-object.
Last updated: Oct 12, 2015