Server binding kendo grid without exposing database context in the controller

[Leah]

Hi,

I am expecting a large amount of data to be displayed in the grid and used paging. I tried to use the Kendo.Mvc.Extensions ToDataSourceResult method but don't want to expose my context in the controller. Is there any way to achieve this?

[Georgi]

Hello Leah,

I would recommend you to use a Service Layer. In other words create a separate classes called "services". Put them in different class library (or namespace) project and make them independent on MVC framework infrastructure. 

You will find a sample which demonstrates the usage of a Service Layer in the link below:

• https://msdn.microsoft.com/en-us/vs2010trainingcourse_aspnetmvcdependencyinjection_topic2

Regards,
Georgi
Progress Telerik

[Leah]

Hi Georgi,

I found a simple solution in stackoverflow by doing the code below.

The repository method with no reference to Kendo:

public T GetSales<T>(Func<IQueryable<SalesOrderHeader>, T> processQueryable)
{
    using (var c = new AdventureWorks2012Context())
    {
        return processQueryable(c.SalesOrderHeaders);
    }
}

To use it you need a function to process the iqueryable as parameter, in this case it returns a DataSourceResult:

public JsonResult Post([DataSourceRequest] DataSourceRequest request)
{
    DataSourceResult sales = salesService.GetSales<DataSourceResult>
           (headersQuery=>headersQuery.ToDataSourceResult(request));

    return Json(sales , JsonRequestBehavior.AllowGet);
}

[Georgi]

Hello Leah,

I am glad to hear that you managed to resolve your query and thank you for sharing your solution with the community.

In case further questions related to the initial one arise at any point, you can reply to this thread.
 

Regards,
Georgi
Progress Telerik