praeclarum / sqlite-net

Simple, powerful, cross-platform SQLite client and ORM for .NET
MIT License
4.01k stars 1.42k forks source link

Windows Universal App #279

Closed ghost closed 7 years ago

ghost commented 10 years ago

Hi there,

I'm making a universal app for windows 8.1 and windows phone 8.1 To get the desktop code to work I had to add a nuget reference to "SQL for Windows Runtime", this works great, but I have no idea where the Windows Phone 8 version is.

Any ideas?

Nick

timheuer commented 10 years ago

I need to update the NuGet package to add the target...the code is actually the same.


http://timheuer.com/blog/ twitter: @timheuer

On Tue, Apr 15, 2014 at 9:58 AM, Nick Pateman notifications@github.comwrote:

Hi there,

I'm making a universal app for windows 8.1 and windows phone 8.1 To get the desktop code to work I had to add a nuget reference to "SQL for Windows Runtime", this works great, but I have no idea where to Windows Phone 8 version is.

Any ideas?

Nick

— Reply to this email directly or view it on GitHubhttps://github.com/praeclarum/sqlite-net/issues/279 .

ghost commented 10 years ago

Hi Tim,

I tried modifying the manifest files but even though it installs and adds to the project, it doesn't copy the dll over, I copied it over manually and it still said it wasn't there which makes me think I've messed up somewhere.

<?xml version="1.0" encoding="utf-8" ?> <FileList DisplayName="SQLite for Windows Phone 8.1" ProductFamilyName="SQLite.WinP81" MoreInfo="http://www.sqlite.org/" MinVSVersion="12.0" AppliesTo="WindowsAppContainer" DependsOn="Microsoft.VCLibs, version=12.0" SupportsMultipleVersions="Error" SupportedArchitectures="x86;x64;ARM">

SQLite for Windows Phone 8.1 SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. http://www.sqlite.org/docs.html http://www.sqlite.org/releaselog/3_8_4_1.html http://www.sqlite.org/ license.txt icon.png preview.png sqlite, sql, database

The DLL reference is resolved according to visual studio and I can find it in the path, it's just not deployed, maybe this is a security thing I've overlooked of executing native code on wp8?

Nick.

Sent from Windows Mail

From: Tim Heuermailto:notifications@github.com Sent: ?Tuesday?, ?15? ?April? ?2014 ?19?:?32 To: praeclarum/sqlite-netmailto:sqlite-net@noreply.github.com Cc: Nick Patemanmailto:nick@npSoftware.co.uk

I need to update the NuGet package to add the target...the code is actually the same.


http://timheuer.com/blog/ twitter: @timheuer

On Tue, Apr 15, 2014 at 9:58 AM, Nick Pateman notifications@github.comwrote:

Hi there,

I'm making a universal app for windows 8.1 and windows phone 8.1 To get the desktop code to work I had to add a nuget reference to "SQL for Windows Runtime", this works great, but I have no idea where to Windows Phone 8 version is.

Any ideas?

Nick

Reply to this email directly or view it on GitHubhttps://github.com/praeclarum/sqlite-net/issues/279 .

Reply to this email directly or view it on GitHubhttps://github.com/praeclarum/sqlite-net/issues/279#issuecomment-40517270.

timheuer commented 10 years ago

You are referring to two things here. This (SQLite-net) is a .NET callable library to access SQLite (the database engine). The manifest you are editing is for the SQLite database engine SDK and not SQLite-net. For the engine, email me privately for an unofficial build (it is going through testing now).


http://timheuer.com/blog/ twitter: @timheuer

On Wed, Apr 16, 2014 at 12:37 AM, Nick Pateman notifications@github.comwrote:

Hi Tim,

I tried modifying the manifest files but even though it installs and adds to the project, it doesn't copy the dll over, I copied it over manually and it still said it wasn't there which makes me think I've messed up somewhere.

<?xml version="1.0" encoding="utf-8" ?> <FileList DisplayName="SQLite for Windows Phone 8.1" ProductFamilyName="SQLite.WinP81" MoreInfo="http://www.sqlite.org/" MinVSVersion="12.0" AppliesTo="WindowsAppContainer" DependsOn="Microsoft.VCLibs, version=12.0" SupportsMultipleVersions="Error" SupportedArchitectures="x86;x64;ARM">

SQLite for Windows Phone 8.1 SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. http://www.sqlite.org/docs.html http://www.sqlite.org/releaselog/3_8_4_1.html http://www.sqlite.org/ license.txt icon.png preview.png sqlite, sql, database

The DLL reference is resolved according to visual studio and I can find it in the path, it's just not deployed, maybe this is a security thing I've overlooked of executing native code on wp8?

Nick.

Sent from Windows Mail

From: Tim Heuermailto:notifications@github.com Sent: ?Tuesday?, ?15? ?April? ?2014 ?19?:?32 To: praeclarum/sqlite-netmailto:sqlite-net@noreply.github.com Cc: Nick Patemanmailto:nick@npSoftware.co.uk

I need to update the NuGet package to add the target...the code is actually the same.


http://timheuer.com/blog/ twitter: @timheuer

On Tue, Apr 15, 2014 at 9:58 AM, Nick Pateman notifications@github.comwrote:

Hi there,

I'm making a universal app for windows 8.1 and windows phone 8.1 To get the desktop code to work I had to add a nuget reference to "SQL for Windows Runtime", this works great, but I have no idea where to Windows Phone 8 version is.

Any ideas?

Nick

Reply to this email directly or view it on GitHub< https://github.com/praeclarum/sqlite-net/issues/279> .

Reply to this email directly or view it on GitHub< https://github.com/praeclarum/sqlite-net/issues/279#issuecomment-40517270>.

— Reply to this email directly or view it on GitHubhttps://github.com/praeclarum/sqlite-net/issues/279#issuecomment-40571284 .

girishnuli commented 10 years ago

Hello Tim,

I see that sqlite-net loads fine on an universal portable class library. Unfortunately, the database engine does not yet support universal pcl. You mentioned above that an unofficial build of the database engine exists - does this work with universal pcl? If yes, could you please share the link with me?

Thanks.

timheuer commented 10 years ago

SQLite has released a build that works with phone last month

-th

Sent from mobile - please excuse tone and brevity

On Jun 13, 2014, at 8:36 AM, Girish notifications@github.com wrote:

Hello Tim,

I see that sqlite-net loads fine on an universal portable class library. Unfortunately, the database engine does not yet support universal pcl. You mentioned above that an unofficial build of the database engine exists - does this work with universal pcl? If yes, could you please share the link with me?

Thanks.

— Reply to this email directly or view it on GitHub.

girishnuli commented 10 years ago

Thanks Tim. I was looking if there is a universal portable class library build available. Currently it looks like there are only Windows 8.1 and Windows Phone 8.1 specific builds.

timheuer commented 10 years ago

For the database you still need two. Frank is working on releasing a PCL here for SQLite-net api wrapper soon

-th

Sent from mobile - please excuse tone and brevity

On Jun 14, 2014, at 6:59 AM, Girish notifications@github.com wrote:

Thanks Tim. I was looking if there is a universal portable class library build available. Currently it looks like there are only Windows 8.1 and Windows Phone 8.1 specific builds.

— Reply to this email directly or view it on GitHub.

KalKal1976 commented 10 years ago

Hello Tim. I develop app for WPF and SQLite.NET - PCL is super, but i need tihis application develop for WinRT 8.1 and WP 8.1 too. Please can you tell me in which time you upgrade nuget target for WinRT 8.1 a WP 8.1? Thanks.

Gillardo commented 9 years ago

Oh this would make my life sweeter... Do you have timescales?

praeclarum commented 7 years ago

Please update to the nuget package sqlite-net-pcl for a lot of improvements here.