Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

Benedikt Neuhold wrote: > > we are building an App for Windows 8 and want to use sqlite as local DB. We > want to separate our Models from our DB Engine. So we need a way to set the > Primary Key without DataAnnotation. Is there a way? > I'm trying to figure out if I'm understanding your

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

We achieved something similar by doing the following: Creating a seperate assembly for our entities Define the primary key attribute in that assembly, but inside the SQLite namespace. Comment out the primary key attribute in the SQLite/net project to avoid re-defining it. We were then able to

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

If I understood you right... 1) Create teable without primary key. 2) Separately create unique index on the column you want to be primary key. > Hi, > > > > we are building an App for Windows 8 and want to use sqlite as local DB. We > want to separate our Models from our DB Engine. So we need

Re: [sqlite] Conditional JOIN

> Apparently, SQLite always executes the join before evaluating other > conditions. > > Try something like this: > > SELECT * > FROM Big INNER JOIN Small ON Big.ID = Small.BigID > UNION ALL > SELECT *, NULL, NULL, ... > FROM Big > WHERE NOT flag > This is indeed a nice solution! But

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

Le 1/04/2014 15:08, Harmen de Jong - CoachR Group B.V. a écrit : We have built our own SQLite database server application and are considering making this open source. Since there will be some time involved into making it an open source project and maintaining it, we would first like to make an

[sqlite] Any interest for open source multi-user 'SQLite database server' application?

We have built our own SQLite database server application and are considering making this open source. Since there will be some time involved into making it an open source project and maintaining it, we would first like to make an inventory to find out if there is any interest in this server

Re: [sqlite] who provides support on SQLite?

Hi, > On 31 Mar 2014, at 22:15, wrote: > Who provides "support" of this product in case of production-related issues. > Is there a paid third-party support available? https://www.sqlite.org/support.html Andreas ___ sqlite-users

[sqlite] Execute individual test case; a race condition test case

Hi, I'm a new user of sqlite3. I would like to have a try on a fixed bug which is a race condition. If I made any wrong assumption, please correct me. What I am seeking for are: A race condition version of SQLite3 and a race condition triggering input. According to the repository timeline

[sqlite] who provides support on SQLite?

Hello, My name is Dinesh. While researching on SQLite, I come to this question. Who provides "support" of this product in case of production-related issues. Is there a paid third-party support available? Thanks Dinesh Dhokai Lead DBA ___ sqlite-users

[sqlite] Primary Key without DataAnnotation for Windows Runtime

Hi, we are building an App for Windows 8 and want to use sqlite as local DB. We want to separate our Models from our DB Engine. So we need a way to set the Primary Key without DataAnnotation. Is there a way? Thanks a lot! ___ sqlite-users

Re: [sqlite] Conditional JOIN

Pavlo wrote: >> Pavlo wrote: >>> I want to lookup small tables only when flag is set but I can't see >>> how to tell SQLite to skip JOIN lookup for certain rows and return >>> NULLs. >> >> SELECT * FROM Big LEFT JOIN Small ON Big.flag AND Big.ID = Small.BigID > > Sadly, you are wrong here. >

Re: [sqlite] Conditional JOIN

Hey Clemens. Thank you for your reply! > Pavlo wrote: > > What I have is one big table storing all mandatory properties of an entity > > and several small tables, storing optional properties. > > > > So, when I need to select big number of elements using JOIN the probability > > of optional