Devart Forums

Code: Select all

CREATE TABLE test_table ( 
   description varchar(255) DEFAULT NULL);

Code: Select all

[Table(Name = @"""main"".test_table")]
public partial class TestTable : INotifyPropertyChanging, INotifyPropertyChanged
{
    ...
    private string _Description = @"NULL";
    ...
}

Code: Select all

from uu in DB.UserUsers
join uc in DB.UserConfigurations on uu.Id equals uc.Id_user
group uc.Config_key by uu.Id into grp
select new { IdUser = grp.Key, GroupCount = grp.Distinct().Count() }).ToList();

Code: Select all

SELECT uu.id, COUNT(DISTINCT uc.Config_key)
FROM user_user uu JOIN user_configuration uc ON uu.id = uc.id_user
GROUP BY uu.id

Code: Select all

public override void SubmitChanges()
        {
            if (this.Transaction != null) 
            {
                base.SubmitChanges();
                return;
            }

            if (this.Connection.State == ConnectionState.Closed)
                this.Connection.Open();
            using (this.Transaction = this.Connection.BeginTransaction(IsolationLevel.RepeatableRead))
            {
                base.SubmitChanges();
                this.Transaction.Commit();
            }
        }

Code: Select all

using (SQLiteConnection conn = new SQLiteConnection("Data Source=ms-appdata:///local/main.db;Read Uncommitted=true;Busy Timeout=15000;Connection Timeout=60;Foreign Key Constraints=Off")) 
{
   using (SQLiteCommand cmd = new SQLiteCommand("ATTACH [second_db] AS db2", conn))
       cmd.ExecuteNonQuery();

   sbQuery.Append("BEGIN TRANSACTION;"); 
   sbQuery.Append("INSERT INTO t1 (...) SELECT ... FROM db2.t1;");
   sbQuery.Append("END TRANSACTION;");

   using (SQLiteCommand cmd = new SQLiteCommand(sbQuery.ToString(), conn))
      cmd.ExecuteNonQuery();
}

Code: Select all

PRAGMA foreign_keys = FALSE;PRAGMA synchronous=OFF;PRAGMA count_changes=OFF;PRAGMA journal_mode=OFF;PRAGMA temp_store=MEMORY;PRAGMA cache_size = 100000;PRAGMA default_cache_size = 100000;

Code: Select all

SQLiteConnection conn = new SQLiteConnection(_connectionString);
conn.Open();
MyDatabaseContext dbContext = new MyDatabaseContext(conn);
SQLiteCommand cmd = new SQLiteCommand("PRAGMA journal_mode = TRUNCATE", conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
return dbContext;

Code: Select all

SQLiteConnection conn = SQLiteConnection(ConnectionString)
conn.Open();
SQLiteTransaction trans = conn.BeginTransaction()

SQLiteCommand cmd = new SQLiteCommand("UPDATE t SET NAME='a' WHERE ID = 1"; conn);
cmd.CommandType = CommandType.Text;
cmd.Transaction = trans;
cmd.ExecuteNonQuery();
cmd = new SQLiteCommand("UPDATE t SET NAME='b' WHERE ID = 2"; conn);
cmd.CommandType = CommandType.Text;
cmd.Transaction = trans;
cmd.ExecuteNonQuery();
trans.Commit();

Code: Select all

SQLiteConnection conn1 = new SQLiteConnection(ConnectionString);
conn1.Open();
SQLiteConnection conn2 = new SQLiteConnection(ConnectionString);
conn2.Open();

Code: Select all

Devart.Data.SQLite.SQLiteException:
  Message=Unable to open database file
  Source=Devart.Data.SQLite
  ErrorCode=0
  StackTrace:
       at   . ()
       at   ..ctor(    )
       at   .      (    , Object  , DbConnectionBase  )
       at   . (    ,     , DbConnectionBase  )
       at   . (    , DbConnectionBase  )
       at   . (DbConnectionBase  )
       at   . (DbConnectionBase  )
       at   . (DbConnectionBase  )
       at  .     (DbConnectionBase  )
       at Devart.Common.DbConnectionBase.Open()
       at Devart.Data.SQLite.SQLiteConnection.Open()

Code: Select all

Data Source=ms-appdata:///local/database.db;Read Uncommitted=true;Busy Timeout=15000;Connection Timeout=60;Foreign Key Constraints=On;Pooling=True;Max Pool Size=100;

Code: Select all

Error Loading assembly "C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0\ExtensionSDKs\DevartLinqConnectMetro\4.0\References\CommonConfiguration\neutral\Devart.Data.dll" failed. System.IO.FileLoadException: Could not load file or assembly 'Devart.Data, Version=5.0.591.1, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. 
Strong name validation failed. (Exception from HRESULT: 0x8013141A)
File name: 'Devart.Data, Version=5.0.591.1, Culture=neutral, PublicKeyToken=09af7300eec23701' ---> System.Security.SecurityException: Strong name validation failed. (Exception from HRESULT: 0x8013141A)

Code: Select all

CREATE TABLE `data_currency` (
  `Id` smallint(6) NOT NULL AUTO_INCREMENT,
  `Currency` varchar(15) NOT NULL,
  PRIMARY KEY (`Id`)
) 

Code: Select all

DB.DataCurrencies.Where(c => c.Id == 1).SingleOrDefault();

Code: Select all

Specified cast is not valid
Devart.Data.Linq.Engine.SingleKeyManager`2.a(Object[] A_0)
Devart.Data.Linq.Engine.KeyManager`2.b(Object[] A_0)
Devart.Data.Linq.Engine.ah.a(Expression A_0, Object& A_1)
Devart.Data.Linq.Engine.ah.e(Expression A_0)
Devart.Data.Linq.DataProvider.a(Expression A_0)
Devart.Data.Linq.Engine.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)

Code: Select all

short id = 1;
DB.DataCurrencies.Where(c => c.Id == id).SingleOrDefault();