[Solved] Demo for SQL Data access with WIN8 Program

[Volker]

Hy,
i have to access data which reside on an SQL Server in WIN8 Programs.
i think this should be easy with the new Feature of ORM (ASP.NET Web API services).
But i dont find a demo in the ORM SDK.
Is there a short Demo (or can you create one), where we can see what is to do in ORM and in the Windows 8 Program to get the SQL Data? (Display Edit, Append and Delete).

Volker

[Joan]

Volker, are you refering to Windows 8 Metro Apps or desktop applications?
Metro apps will not be able to connect directly to SQL, but they can connect to a service.  If you separate the data layer into a service, you will be able to create a very robust front end and you can also connect different front ends to the same service project.

If you need a local database, you can use SQLite and keep the whole app self contained.

Joan.

[Volker]

 >are you refering to Windows 8 Metro Apps or desktop applications
I refere for WIndows metro Apps.

My Question was for a Small Demo Programm which uses ORM (Which connect to a SQL Database) and Metro Apps which connect to ORM and Display Edit, Append and Delete Data.
In ORM there are many Demos, but no WIth Metro Style Apps.

Volker

[Lini]

Hello,

Metro applications run in a sandboxed environment and have no direct access to a local or remote SQL server. This means that you can only use a service (e.g. WCF) in a separate project and consume it from the Windows Store application. Refer to the OpenAccess ORM Programmer's guide for more information on setup and implementation of the WCF service - http://www.telerik.com/help/openaccess-orm/getting-started-wcf-services.html

Regards,
Lini
the Telerik team