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.
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
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?