Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-07 Thread Matjaž Cof
am close. Any idea now? 2012/4/7 Joe Mistachkin <sql...@mistachkin.com> > > Matjaž Cof wrote: > > > > Thank's to all. > > Stupid me. But still not working. Is there any documentation how to > compile > > SQLite.NET.2010 solution with SQLITE_DEFAULT_FOR

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-06 Thread Matjaž Cof
- downloaded from http://system.data.sqlite.org/downloads/1.0.80.0/sqlite-netFx40-binary-Win32-2010-1.0.80.0.zip ). Is there any documentation, how is SQLite.Interop.2010 project integraded into System.Data.SQLite.2010 project? 2012/4/6 Joe Mistachkin <sql...@mistachkin.com> > > Matj

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-06 Thread Matjaž Cof
with SQLITE_DEFAULT_FOREIGN_KEYS. 2012/4/6 Simon Slavin <slav...@bigfraud.org> > > On 6 Apr 2012, at 1:50pm, Matjaž Cof <nov...@svetiduh.si> wrote: > > > But here is the problem. For foregein key i can insert any value even if > > inserted ID not exist in reference t

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-06 Thread Matjaž Cof
chkin <sql...@mistachkin.com> > > Matjaž Cof wrote: > > > > I recompiled it, add reference to System.Data.SQlite and > > System.Data.SQLite.Linq to my project and run. I get: The type > > initializer for 'System.Data.SQLite.SQLiteFactory' threw an exceptio

[sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-05 Thread Matjaž Cof
I am trying something, and i am confused as far as i can be. I only want that SQlite would enforce foreign key constraint by default. I don't want to use PRAGMA foreign_keys every time i mada a connection. After searching on net, i found that i can compile with SQLITE_DEFAULT_FOREIGN_KEYS. I