Is possible to use "LINQ to SQL" database in Windows 8 metro apps?

Question

Hi,

In my C# windows 8 metro app, i need use local database.Is it possible to use "LINQ to SQL" database in windows 8 apps. or any other easy option is there to use local database.

Answer 1

Hi,

It seems there is no official announcement of support for Linq to Sql or EF for database access in Windows 8 Metro Apps. You can try to use web services to access the data.

You can try to use SQLite to store local data. Check this link for more details Using SQLite in a Metro style app. Take a look at the third party component Devart LinqConnect if you are looking for a ORM solution.

Also refer the following links.

Can I use Entity Framework or Linq To SQL with Windows 8 Metro Style apps?

Using SQLite in your Windows 8 Metro style applications

Generic Object Storage Helper for WinRT

---

Microsoft MVP - ASP/ASP.NET