[sqlite] Why is SQLiteConnection.DataSource set as the database file without its extension?

Hi, Is there a reason why SQLiteConnection.DataSource is set to the database file without the extension? // System.Data.SQLite.SQLiteConnection public override void Open(){ ... _dataSource = Path.GetFileNameWithoutExtension(fileName); ... } Kindly, Ludovic

Re: [sqlite] system.data.sqlite 1.0.81.0 - .edmx creation issue

sert into Lesson2 (title) values ('Abc'); > insert into lesson2 (title) values ('Def'); <<< lower case > works fine > insert into Page2 (lesson_id, title) values (1,'xxx'); > insert into page2 (lesson_id, title) values (2,'yyy'); > insert

[sqlite] system.data.sqlite 1.0.81.0 - .edmx creation issue

Hello, I was having a hard time understanding why a one-to-many relationship wasn't included in the .edmx of an Sqlite database, until I figured the issue is with the letter case of the referenced table in the foreign key definition. The following works ok: CREATE TABLE Lesson (    id INTEGER P

[sqlite] SELECT statement seems to return incorrect results

Hi, REF: http://stackoverflow.com/questions/10171403/why-does-select-results-differ-between-mysql-and-sqlite Consider these statements: create table foo (id INT, score INT); insert into foo values (106, 4);insert into foo values (107, 3);insert into foo values (106, 5);insert into foo values (10