DevExpress Dashboard - Data Access Engine (Coming soon in v15.1)

Thinking Out Loud
02 June 2015

With the v15.1 release, the DevExpress .NET Dashboard Designer includes new data access capabilities, including connection to stored procedures, use of dashboard parameters as SQL query parameters, Entity Framework/object data source binding, and more...

Dashboard Stored Procedure Support

A new Data Source wizard allows you to connect to stored procedures contained within SQL databases. You simply specify connection settings and select the required stored procedure.

Once complete, you can specify parameter values passed to the stored procedure.

DevExpress Dashboard for .NET - Data Source Wizard SQL Stored Procedures

In addition, you can pass a dynamic dashboard parameter to the stored procedure call.

Query and Dashboard Parameters

As you'll see once we ship v15.1, the Data Source wizard also allows you to pass dashboard parameters to custom SQL queries or stored procedures. To pass a dashboard parameter to a SQL query, create a query parameter, enable the Expression checkbox and select the corresponding dashboard parameter.

DevExpress Dashboard for .NET - Query Parameters

You can then change the current parameter value within the Dashboard Parameters dialog. This value will be passed to the custom SQL query.

DevExpress Dashboard for .NET - Query Parameters

You can pass dashboard parameters to stored procedure calls in a similar way.

DevExpress Dashboard for .NET - Stored Procedure Parameters


Entity Framework and Object Data Sources

This update brings with it Entity Framework and Object data sources support.

To use an Entity Framework data source for your dashboard data source, select the required context from the current project or an external assembly...and then specify the connection string to your data store.

DevExpress Dashboard for .NET - Entity Framework Support

Object data sources allow you to use custom objects as a dashboard data source. For instance, you can use either a DataSet object created at design time within Visual Studio or any class providing data.

That wraps up this post about enhancements we've made to the DevExpress Dashboard's data access engine. As always, we do welcome your feedback so please tell us what you think.

1 comment(s)
Jonatas Hudler
Jonatas Hudler

In our case, we've decided about not using EF as our ORM, but another IQueryable-compliant framework instead. Is there a way to manage this case? I was hoping a solution more straightforward like the "Pivot Grid IQueryable server mode" binding style.

2 June, 2015

Please login or register to post comments.