Reference to System.Data.dll needed

[frank.sarlemijn]

Installed dotconnect for sqlite product and referenced the nuget package. Created a new universal project.

this code:

SQLiteConnection connection = new SQLiteConnection();

gives several errors in compilation, all suggesting I should add a reference to system.data.dll why? how?


thanks.

[Pinturiccio]

dotConnect for SQLite is an ADO.NET provider. The System.Data.dll assembly contains base ADO.NET classes, and this assembly is necessary for any ADO.NET provider. It's easy to find the System.Data.dll assembly, because it is a part of .NET Framework, which is required for dotConnect for SQLite. For more information, please refer to http://www.devart.com/dotconnect/sqlite ... ility.html

[frank.sarlemijn]

I am building a universal project/app. I can not make a reference to system.data. Meanwhile I found another of your products that suits my needs better. What I don't understand is that now I have to buy 2 products, one for Phone and one for WinRT. Is there a possibility for a discount?

[MariiaI]

dotConnect for SQLite doesn't provide support for WinRT and Windows Phone 8 (8.1).
At the moment, WinRT support is available in LinqConnect for Metro only. For more information about LinqConnect for Metro please refer to:
http://www.devart.com/linqconnect/metro ... nnect.html
http://blog.devart.com/linqconnect-for- ... guide.html

Windows Phone support is available in LinqConnect for Windows Phone. For more information about LinqConnect for Windows Phone please refer to: http://www.devart.com/linqconnect/windo ... nnect.html

These products are a fully-functional ORM solutions for the Windows 8 Metro and Windows Phone platforms. They offer their own managed embedded database engine based on C# SQLite to store data locally in a fully functional local relational database. Moreover, the data providers that implement ADO.NET interfaces are included, so you can also work with these providers directly (if, for some reason, you don't want to use an ORM).

However, regarding Universal Apps (8.1), we recommend you to use LinqConnect for Metro for both parts of the Universal App (Windows 8.1 and Windowes Phone 8.1).
Unfortunately, currently we can't add full support for Windows Phone 8.1 in LinqConnect for Windows Phone edition due to the some peculiarities and complexity of its realization.
Thus, LinqConnect for Metro edition can be used for this purpose.

Please download LinqConnect for Metro Trial to see if it suits your needs and try performing these steps:
1) install LinqConnect for Metro Trial edition;
2) add manually references to the assemblies from this directory: C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1\ExtensionSDKs\DevartLinqConnectMetroSQLite\4.0\References\CommonConfiguration\neutral (for Windows Phone 8.1 project); in Windows 8.1 project you can add the assemblies by adding "Devart LinqConnect for Windows 8.1 (SQLite)" ExtensionSDK via Add Reference -> Windows 8.1 -> Extensions;
3) build the solution;
4) make sure the compiled license resource DEVART.DATA.SQLite.LINQ.dll.licenses file is available in the Properties folder of the project;

Regarding the 4 step: The license resource file is created automatically in case LinqConnect for Metro is integrated into Visual Studio. If this file is not generated in your project automatically, please notify us about it and we'll send it you.
JIC: When working with a non-trial version of LinqConnect for Metro, there is no need to generate license resource files.
Feel free to contact us if anything is unclear.

If you have any questions regarding purchasing, discounts, etc., please contact our Sales department at sales at devart dot com.

[frank.sarlemijn]

the license files are not present in my project but I do not get any error(s) regarding the missing license, tests against the shared part of the project succeed. I added the references manually to my Phone project and that builds as well, so far everything seems to work as advertised.

Thank you for the support.

[MariiaI]

If you encounter any issues with this or have any further questions, please let us know.