How to use the transaction?

I'm having an issue when I want to insert some datas. When I want to add 3 articles, the 2 first are inserted but at the 3rd one an "SQLiteException' is thrown without any innerException. It seems...

Id #43402 | Release: None | Updated: Apr 20, 2016 at 2:48 PM by s0nyk | Created: Apr 20, 2016 at 2:48 PM by s0nyk

OpenNETCF.ORM.KeyScheme.None fails to save

Problem Entities with OpenNETCF.ORM.KeyScheme.None fail to Insert because they fail to get the Identity. Identity was provided (the records are linked to external database's record). Solution add...

Id #43396 | Release: None | Updated: Apr 14, 2016 at 2:11 PM by gowalmsley | Created: Apr 14, 2016 at 2:10 PM by gowalmsley

Issue with Connections in Pool being closed and unusable

Using SQLCE on compact framework 3.5 with CE6. The connection in the connection pool was closed and had no connection string. The GetPoolConnection method returned an unusable connection. I did n...

Id #43395 | Release: None | Updated: Apr 14, 2016 at 1:52 PM by gowalmsley | Created: Apr 14, 2016 at 1:52 PM by gowalmsley

System.ArgumentNullException in SQLStoreBase.GetPoolConnection()

I'm attempting to use the ORM with SQLite in a small full framework app but it was throwing the following exception when I attempted to do anything with the database. System.ArgumentNullException w...

Id #43375 | Release: None | Updated: Mar 21, 2016 at 6:49 PM by cvboucher | Created: Mar 21, 2016 at 6:49 PM by cvboucher

Documentation - "Defining a Discoverable Entity" Misleading or Incorrect

This documentation page makes mention of the IsIdentity attribute, which is not available on CF (at least, I have not tested others). Regardless of whether this is deliberately unavailable on ORM f...

Id #43360 | Release: None | Updated: Feb 24, 2016 at 11:02 AM by malucul | Created: Feb 24, 2016 at 11:02 AM by malucul

ObjectDisposedException in SQLite for CF

First of all, I'm using the code compiled referencing the last version of System.Data.SQLite for CF (1.0.98.0) which uses SQLite 3.8.11.1 When trying to get a valid connection from the pool, Objec...

Id #43253 | Release: None | Updated: Nov 18, 2015 at 12:30 PM by rodrigoavots | Created: Oct 1, 2015 at 4:20 PM by farlop

Self reference implementation

Hi I tested every way for self reference in my model but no result i catch. please help if this feather implemented. best regard public class Department { public int DepartmentId { get; set } pub...

Id #35820 | Release: None | Updated: Feb 1, 2015 at 3:30 PM by payervand | Created: Feb 1, 2015 at 3:30 PM by payervand

Issue with SQLiteDataStore and fetchCount?

Hi, I updated to check in #105316 a while ago to add support for some SQLite requirements (running on various platforms including Windows 8.1) All appeared to work well but an issue has been rais...

Id #35709 | Release: None | Updated: Nov 25, 2014 at 11:54 AM by ajlennon | Created: Nov 25, 2014 at 11:53 AM by ajlennon

Suggested Changes

Hi, I would like to ask if you may add a few changes to the SQL server part. With the connection settings add capability to change the connection timeout like below. public class SqlConnectionInf...

Id #35390 | Release: None | Updated: Jul 17, 2014 at 9:11 PM by RiaanSwart | Created: Jul 17, 2014 at 9:11 PM by RiaanSwart

Support for fetchCount on filtered Select()

I found it useful for application performance to add a new Select<T> method to SQLStorebase.cs to support selection with both an IENumerable<FilterCondition> and a fetchCount. There may be better...

Id #35258 | Release: None | Updated: May 28, 2014 at 3:49 PM by ctacke | Created: May 28, 2014 at 1:24 PM by ajlennon