Re: [sqlite] An issue with System.Data.SQLite

2017-12-22 Thread Joe Mistachkin
Aleksey Lulchenko wrote: > > Please, give me the clues what is going wrong, if you can. I think it > is a typical bug in many situations. > Could you please show us the schema of the table (or tables) involved? -- Joe Mistachkin ___ sqlite-users ma

Re: [sqlite] An issue with System.Data.SQLite

2017-12-22 Thread Barry
Do you allow the entity framework to create your database, or do you do it yourself? You need text affinity on the columns in question. Then any numbers will be stored as text, not numbers. See: https://sqlite.org/datatype3.html Particularly: 3.1. Determination Of Column Affinity The affinity

[sqlite] An issue with System.Data.SQLite

2017-12-22 Thread Алексей Люльченко
Dear Sir! I would like to ask you to help me with an issue which appears while I use System.Data.SQLite database engine. I use .net framework 4.0.0, EntityFramework 6.2.0 and SQLite 1.0.106. I have an entity with properties of string type. This entity is mapped to my database table which has the