in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

using a dataset to create a new sqlite db

Last post 12-18-2007 11:10 PM by Nazguy. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-13-2007 6:34 AM

    • Eps
    • Not Ranked
    • Joined on 10-13-2007
    • Posts 1

    using a dataset to create a new sqlite db

    I am prototyping a new app and have been using a dataset to store the db so far (writing/reading to an xml file), nost surprisingly now the dataset is quite large the performance is not very good.

     
    Is there an easy way to set the schema for the sqlite db to be the same as the dataset ?, or do I have to do it manually ?

     Any help appreciated.

     

  • 10-15-2007 7:45 AM In reply to

    Re: using a dataset to create a new sqlite db

    Answer

    You'll have to create the database, schema and relationships yourself I'm afraid.

    Robert

     

  • 12-18-2007 11:10 PM In reply to

    • Nazguy
    • Not Ranked
    • Joined on 12-18-2007
    • Posts 1

    Re: using a dataset to create a new sqlite db

    Yes you can do it programatically.  You would basically just have to loop through the tables in the dataset, read out the schema, and build your create table and insert statements.  I've done this in a fairly generic sense for some software I worked on recently where I receive datasets from a webservice and have to create, fill, and update tables on the client.  You've probably already solved your problem since you posted 2 months ago, but you never know.

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems