Json example

[Jigar]

Hello,

I am creating one hybrid mobile application and i want to fetch data from SQL server so can you give me any hint or demo example for that as soon as possible.

 

Thank you

Jigar

[Anton Dobrev]

Hi Jigar,

Based on the information you provided I am assuming that you have an existing SQL database and you would like to consume the data from it in your mobile app. You may want to consider a few approaches, either integrated in Telerik Platform, or that require additional development efforts on your end. To do this you will need to have a web services layer on top of the SQL database and consume the data through HTTP requests from the client app.

The integrated solution in Telerik Platform allows you to achieve this by installing a Data Connector in your infrastructure, also available for Linux. After that you can quickly expose the database tables and stored procedures through HTTP endpoints. Consume the data from the endpoints from your client app using the JavaScript SDK of Backend Services or jQuery Ajax requests.

Using this approach allows you to use web services with offline synchronization mechanism out-of-the-box.

The latest sample project of Backend Services is available in this repository. You can clone it directly in your Telerik Platform account by clicking on this link. More samples could be explored here.

You may also consider using the Telerik Data Access services wizard to quickly scaffold and build a web services layer on top of the SQL database, and deploy them to your own web server.

A third approach might be to build your web services with a technology like ASP.NET Web API (for .NET), or frameworks like Spring for Java.

When you have your web services layer ready, proceed with connecting the mobile app to them, for example, with Kendo UI DataSource that feeds Kendo UI mobile widgets. Demos for all widgets are available here. You can also work with these services with HTTP requests.

Let me know if this helps.

Regards,
Anton Dobrev
Telerik