in

SQLite provider, "no such table" exception when saving item

Last post 02-26-2008 12:09 AM by dalziel. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-24-2008 11:25 PM

    • dalziel
    • Top 500 Contributor
    • Joined on 11-26-2007
    • Sydney, Australia
    • Posts 7

    SQLite provider, "no such table" exception when saving item

    I've got a table  'user' in a sqlite database.  I've got the app.config setup ok because SubCommander generates the records, but when I try and do 

                User u = new User() { UserName = userName, Name = name };
                DB.Save<User>(u);

    it chucks an exception inside the SQliteDataProvider (line 246: object result = cmd.ExecuteScalar();):

     SQLite error
    no such table: user

    Anyone else come across this? 

    Filed under:
  • 02-25-2008 11:48 PM In reply to

    Re: SQLite provider, "no such table" exception when saving item

    Not sure whats the problem but isn't it

    User u = new User { UserName = userName, Name = name };

    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk
  • 02-26-2008 12:09 AM In reply to

    • dalziel
    • Top 500 Contributor
    • Joined on 11-26-2007
    • Sydney, Australia
    • Posts 7

    Re: SQLite provider, "no such table" exception when saving item

     The two ways are logically equivalent, the empty braces are just saying to explicitly use the paramaterless constructor, where as not having them just implies it.   Makes no difference either way really.

Page 1 of 1 (3 items)