ISQLitePlatform in SQLConnection method

[piotrek1231]

Hi, I used to sqlite-net and I had created connection using: _sqlLiteConnection = new SQLiteConnection(_pathOfDatabase);

After install sqlite-net extension SQLiteConnection require two parameters. What I should set as the first parameter ?

Thanks

[Guillermo Gutiérrez]

In the SQLite-Net PCL version (https://github.com/oysteinkrog/SQLite.Net-PCL), you have to pass the platform implementation to the SQLiteConnection constructor.

That object is declared in the platform nuget package. For example, for Windows Phone projects you have to include this package: https://www.nuget.org/packages/SQLite.Net.Platform.WindowsPhone8/

If you need more info, please ask in the SQLite-Net PCL project: https://github.com/oysteinkrog/SQLite.Net-PCL

[Guillermo Gutiérrez]

This issue is a SQLite-Net PCL issue

[piotrek1231]

Thanks for reply. Unfortunately SQLite-net PCL not support WP 8.1. Is any way to use sqlite net extension without sqlite-net PCL ?

[Guillermo Gutiérrez]

Yes, you can copy the SQLite-Net Extension sources to your project

[piotrek1231]

When I installed SQLite-Net Extension PCL it added also SQLIte-Net PCL. Could you confirm that my way is right ?

1. Uninstall SQLIte-Net PCL and SQLite-Net Extension PCL
2. Install SQLIte-Net (not PCL)
3. Add to my solution this project

[Guillermo Gutiérrez]

Yes, that should work. I don't know which reflection API you have for WP81, but If you find issues with the reflection API try using the version 1.1.1 of the code.

[piotrek1231]

I added version 1.1.1 to my project. There were many errors connected with json.net and sqllite-net pcl, so I reinstall json.net and I wanted to reinstall sqlite-net PCL, but ... "Could not install package 'SQLite.Net-PCL 2.4.1'. You are trying to install this package into a project that targets 'portable-net45+sl50+win+wp80', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author." In this situation I installed sqlite-net (without PCL), but there are 5 errors connected with this line: "

var relationshipAttribute = relationshipProperty.GetAttribute<RelationshipAttribute>();"

Error: The type 'SQLiteNetExtensions.Attributes.RelationshipAttribute' cannot be used as type parameter 'T' in the generic type or method 'SQLiteNetExtensions.Extensions.ReflectionExtensions.GetAttribute<T>(System.Reflection.PropertyInfo)'. There is no implicit reference conversion from 'SQLiteNetExtensions.Attributes.RelationshipAttribute' to 'System.Attribute'.

Thanks

[Guillermo Gutiérrez]

Did you add the project itself or copied the sources?

These are the steps that you should follow to get it working:

• Add your platform-specific SQLite-Net library to your project
• Make sure that it works (try inserting any simple object)
• Add JSON.Net dependency (it's required by SQLite-Net Extensions for TextBlob attributes)
• Copy the sources of SQLite-Net Extensions (adding the project as a reference won't work!)

Try this and tell me how it goes.

[piotrek1231]

I had copied project, but now I have sourceds added to my project. I develop Universal App, so I install in Windows 8.1 App SQLite-Net and Json.Net. Next, I copied sources from "Attributes", "Exceptions" and "Extensions" to my Shared project. It looks like:

All is right, because for example OneToMany is recognized, but if I use:

_sqlLiteConnection.InsertWithChildren(object); 

I get error: SQLite.SQLiteConnection' does not contain a definition for 'InsertWithChildren' and no extension method 'InsertWithChildren' accepting a first argument of type 'SQLite.SQLiteConnection' could be found (are you missing a using directive or an assembly reference?

[Guillermo Gutiérrez]

If you haven't changed the namespaces, you need to add the following using directive:

using SQLiteNetExtensions.Extensions;

[piotrek1231]

Thanks, it caused by this namespace (VS didn't prompt using this namespace). But now I have a some problems with reflections:

1. 'System.Type' does not contain a definition for 'GetProperties' and no extension method 'GetProperties' accepting a first argument of type 'System.Type' could be found (are you missing a using directive or an assembly reference?)

2. The name 'BindingFlags' does not exist in the current context

Do you know how I can resolve this issue ?

[piotrek1231]

Can I replace

type.GetProperties(BindingFlags.Public | BindingFlags.Instance)

by

type.GetRuntimeProperties()

?

[piotrek1231]

Unfortunately, I can't find equivalent to: 1. type.GetCustomAttributes(typeof(T), true); 2. foreignKeyAttribute.ForeignType.IsAssignableFrom(destinationType) 3. elementType.IsAssignableFrom(inverseType))

etc

[Guillermo Gutiérrez]

Just take the last version of the code. I think that the new reflection API is WP81 compatible

[piotrek1231]

Thanks, It works fine.

[Guilherme Minglini]

Guillermo, Im trying to use SQLite-Net Extensions in a Windows Phone 8.1 app (it is NOT Windows Phone 8.1 Silverlight). I don´t know which version i should use.

If i install the SQLite-Net Extensions-PCL, my SQLConnection class needs two parameters. In the examples, SQLConnection receive the database name as the only parameter. What im doing wrong?

[Guillermo Gutiérrez]

@minglini You can use the sources of the WinRT platform for Windows Phone 8.1: https://github.com/oysteinkrog/SQLite.Net-PCL/tree/master/src/SQLite.Net.Platform.WinRT

[Guilherme Minglini]

@redent Thanks. With the WinRT platform, It is right to create a new SQLConnection like this?

new SQLiteConnection(new SQLitePlatformWinRT(), DATABASE_PATH);

And using the sources of the WinRT platform, i can continue to use the SQLiteNetExtensionsAsync dll, right?

[Guillermo Gutiérrez]

@minglini Yes. The platform is only required to instantiate the connection in the platform-specific code. The rest of the code goes into the shared PCL code.

[Guilherme Minglini]

@redent Im getting this exception when trying to create a new SQLiteConnection:

An exception of type 'System.DllNotFoundException' occurred in mscorlib.ni.dll but was not handled in user code

Additional information: Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

My SQLite references:

Can you help me?

[Guillermo Gutiérrez]

@minglini Probably you didn't install sqlite Visual Studio extension. I'm afraid I cannot be much more useful, I'm not really used to WP8.1 and this is not related to this project at all. You may have more luck asking in the SQLite.Net PCL project page or in StackOverflow.

Once you get SQLite-Net working, SQLite-Net Extensions should work.

[Guilherme Minglini]

@redent That was it. It is now working. Thanks for the help with the sources of the WinRT platform!