IPowerPortalsProService

The IPowerPortalsProService interface provides methods for performing CRUD operations, executing queries, managing relationships, and retrieving metadata from Dataverse. It is the primary service for server-side data access in PowerPortalsPro.

Note

In most cases you do not need to call IPowerPortalsProService directly. The RecordContext, MainContext, and grid components handle data operations automatically. Use this service for custom logic that falls outside the standard component workflow.

Server and Client Implementations

IPowerPortalsProService ships with two implementations registered automatically by the framework — your component code is identical against both, and the runtime injects whichever one matches the active render context:

• Server implementation (PowerPortalsPro.Web.Server, registered by AddPowerPortalsProWebServer) — runs in-process, talks to Dataverse directly through IOrganizationService, and applies your ITablePermissionHandler / ITableRecordPermissionHandler interceptors before any read or write. Selected when the page renders under InteractiveServerRenderMode or static SSR.
• Client implementation (PowerPortalsPro.Web.Client, registered by AddPowerPortalsProWebClient) — runs in the browser under WebAssembly, has no Dataverse SDK at all, and instead JSON-serializes each call out to the corresponding server-side HTTP endpoint (/api/table/{name}, /api/retrieveMultiple, etc.). Permission handlers still apply because the request lands back on the server's endpoint. See the HTTP Endpoints page for the wire format and the routes the client implementation calls.

Because the contract is identical, the same component works under any interactivity mode (Server, WebAssembly, or Auto). Code that calls _powerPortalsProService.RetrieveRecordAsync(...) in a Server-rendered page does an in-process Dataverse call; the same line in a WASM-rendered page issues an HTTP request — no branching required.

Injecting the Service

Inject IPowerPortalsProService into any Blazor component or service via constructor or property injection.

[Inject]
private IPowerPortalsProService _powerPortalsProService { get; set; } = null!;

Retrieving a Record

Use RetrieveRecordAsync to fetch a single record by table name and ID. Optionally specify which columns to return; if omitted, all columns are returned.

// Retrieve all columns
var account = await _powerPortalsProService.RetrieveRecordAsync("account", accountId);

// Retrieve specific columns only
var account = await _powerPortalsProService.RetrieveRecordAsync("account", accountId,
    new[] { "name", "telephone1", "address1_city" });

Querying Multiple Records

Use RetrieveRecordsAsync with a FetchXML query string to retrieve multiple records with filtering, sorting, and linked entity support.

var fetchXml = @"<fetch>
    <entity name='contact'>
        <attribute name='fullname' />
        <attribute name='emailaddress1' />
        <filter>
            <condition attribute='parentcustomerid' operator='eq' value='...' />
        </filter>
        <order attribute='fullname' />
    </entity>
</fetch>";

var response = await _powerPortalsProService.RetrieveRecordsAsync(fetchXml);
foreach (var record in response.TableRecords)
{
    // Process each record
}

Creating a Record

Use CreateRecordAsync to create a new record in Dataverse. The response contains the ID of the newly created record.

var newContact = new TableRecord { TableName = "contact" };
newContact["firstname"] = new StringValue("John");
newContact["lastname"] = new StringValue("Doe");

var response = await _powerPortalsProService.CreateRecordAsync(newContact);
var newRecordId = response.Id;

Updating a Record

Use UpdateRecordAsync to update an existing record. Only the properties set on the TableRecord are sent to Dataverse.

var recordToUpdate = new TableRecord
{
    TableName = "contact",
    Id = contactId
};
recordToUpdate["telephone1"] = new StringValue("555-1234");

await _powerPortalsProService.UpdateRecordAsync(recordToUpdate);

Deleting a Record

Use DeleteRecordAsync to delete a record by table name and ID.

await _powerPortalsProService.DeleteRecordAsync("contact", contactId);

Associating Records

Use AssociateAsync and DisassociateAsync to manage many-to-many relationships between records.

// Associate
var account = new TableRecordReference("account", accountId);
var regions = new List<TableRecordReference>
{
    new TableRecordReference("ppp_region", regionId1),
    new TableRecordReference("ppp_region", regionId2),
};
await _powerPortalsProService.AssociateAsync(account, "ppp_Account_ppp_Region_ppp_Region", regions);

// Disassociate
await _powerPortalsProService.DisassociateAsync(account, "ppp_Account_ppp_Region_ppp_Region", regions);

Executing Requests

Use ExecuteAsync for a single request or ExecuteMultipleAsync to execute multiple requests in a single database transaction. If any request in a transactional batch fails, all changes are rolled back.

// Execute multiple requests in a single transaction
var requests = new List<OrganizationRequest>
{
    new CreateRequest(contact),
    new UpdateRequest(account),
};

var responses = await _powerPortalsProService.ExecuteMultipleAsync(requests, returnResponses: true);

Retrieving Metadata

Use RetrieveTableMetadataAsync and RetrieveViewMetadataAsync to retrieve table and view metadata. For cached access, prefer ITableMetadataCache and IViewMetadataCache instead.

var tableMetadata = await _powerPortalsProService.RetrieveTableMetadataAsync("contact");
var viewMetadata = await _powerPortalsProService.RetrieveViewMetadataAsync(viewId);

Working with Files

Use GetFileInfoAsync to retrieve file or image metadata and optionally the binary content from a file or image column.

// Get file metadata only
var fileInfo = await _powerPortalsProService.GetFileInfoAsync("contact", contactId, "ppp_contract");

// Get file metadata and binary content
var fileWithData = await _powerPortalsProService.GetFileInfoAsync("contact", contactId, "ppp_contract", includeData: true);
var bytes = fileWithData.FileData;