Can't use System.Data.Dll with Unity iOS Basic

Unity Engine
1

Hi,

while trying to implement Sqlite access into my iOS project, following error message occurred while building to iOS target:

Error building Player: SystemException: System.Net.Sockets are supported only on Unity iPhone Advanced. 

Referenced from assembly 'Mono.Data.Tds'.

This happened after I inserted the System.Data.Dll from the unity program folder into my project. ( According to this thread : http://forum.unity3d.com/threads/70589-sqlite-issues!pls-help-me!Thanks! ).

I haven’t any other references to .Net sockets, so I am wondering If this is intended to be like this or should I file a bug report ?

–
oxl

2

Friendly post holiday bump :wink:

3

This is no bug.
System.Data is a standard .NET framework and as such uses what it requires to work, which includes a reference to System.Net (cause aside of sqlite every single other database is network based)
That you can’t use System.Net is a consequence of you not owning iOS Pro and there is nothing that will change that as that limitation is by design.

But nothing prevents you from writing a native code plugin which lets you communicate to sqlite or the whole CoreData framework of iOS for example :slight_smile:

4

ok … thanks for enlighten me ! :slight_smile:

–
oxl

5

Has anyone written (selling) a native code plugin to communicate with SQLite that would work for Unity iOS Basic?

6

I tried using System.Data and System.Data.SQlite with Unity free on windows but it was giving all kinds of errors. I used Mono.Data.SqliteClient instead and it worked ok, maybe you should try it with Unity iOS. Also let me know if it works :slight_smile: