Will dblinq be used for SQLite in checking application storage in the Windows Store?

Question

I was trying to figure out how to get a decent LINQ to work on accessing the ORM database in the Windows Store app. All I found is SQLite and the NuGet package for sqlite-net. The latter sucks in a bit, because I don't get any .dbml-like structure that resolves relationships and provides navigation properties for a simple request (then manual union is not required).

It was interesting to me:

• Does dblinq offer a combination with SQLite?
• Will this password be used to verify the Windows Store?

Thanks!

Update: some links that I used in my research:

• Tim Heyer's famous post on SQLite and Windows 8: http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx
• DBlinq: http://code.google.com/p/dblinq2007/
• sqlite-net: http://code.google.com/p/sqlite-net/
• An interesting discussion with ADO.NET is not possible: http://social.msdn.microsoft.com/Forums/en-US/winappswithcsharp/thread/e9cdd75d-03e4-4577-988e-4c02a52e3f50

Answer 1

I am not familiar with dblinq, but looking at the sqlite tests in the project, it seems that the library offers what you are looking for, i.e. Navigation properties for relationships between different tables.

Since dblinq is a .NET library, the use of this parameter should not lead to a failure of the storage check. However, there is another problem: you cannot use such a .NET library in a Windows Store application, only Windows Store class libraries and portable class libraries are allowed. Since the source for the library is available, you can try to compile it as a Windows Store class library, but I am afraid that some classes will be missing, because dblinq depends on what might make the port difficult.