This sample project demonstrates how to use a custom data adapter.

First, you need to add the StiMvcDesigner component to the view page. Also, you need to pass the StiMvcDesignerOptions object to the constructor. The minimum required options are two actions - GetReport and DesignerEvent:

@using Stimulsoft.Report.Mvc;

...

@Html.Stimulsoft().StiMvcDesigner(new StiMvcDesignerOptions()
{
    Actions =
    {
        GetReport = "GetReport",
        DesignerEvent = "DesignerEvent"
    }
})

Next, add a custom data adapter:

...

	// Clearing standard data adapters, if necessary
	StiOptions.Services.Databases.Clear();

	// Adding a Custom PostgreSQL data adapter
	StiOptions.Services.Databases.Add(new CustomPostgreSQLDatabase());
	StiOptions.Services.DataAdapters.Add(new CustomPostgreSQLAdapterService());

...

In the options above we define several actions, and we need to add it in the controller.

The GetReport() action loads the report template and returns answer to the client part of the designer using the GetReportResult() static method. In the parameters of this method, the report object should be passed:

...

public ActionResult GetReport()
{
	var report = new StiReport();

...

Finally, add a connection to the report:

...

	// Adding a connection to the report from code
	var database = new CustomPostgreSQLDatabase("CustomData1", "Server=127.0.0.1; Port=5432; Database=myDataBase; User Id=myUsername; Password=myPassword;");
	report.Dictionary.Databases.Add(database);

	return StiMvcDesigner.GetReportResult(report);
}

...

Auf dem Screenshot unten Sie können das Ergebnis des Beispiel-Codes ansehen: