in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Browse by Tags

  • Datasets with Foreign Keys back to AutoIncrement field no longer working?

    I have a dataset with several tables. They all reference back to one row whose key is autoincrement. After creating a new record, everything references an ID of -1, as you would expect from autoincrement. In version 1.0.35.1, when I wrote this dataset out using table adapters using the following SQL...
    Posted to Bugs (Forum) by jpwkeeper on 09-23-2011
  • .Net 4.0 & SQLite 1007000 sample

    I created a .net 4.0 WinForm appi with SQLite embedded and want to share the source code.. So here it is [ MyBlog ] [ Code Project ] So have fun and enjoy...
    Posted to How To (Forum) by Kribo on 05-02-2011
  • How to retrieve the last autoincremented ID from a table when using a typed dataset?

    [Noob alert!] I constructed a typed dataset inside VS 2008. I am using the prefabricated datadapters to fill and update its tables. How can I retrieve the last autoincremented ID from a table? I understand that in SQL it is:Select last_insert_rowid(). But how do I call this SQL from C# ADO.Net? Thanks...
    Posted to How To (Forum) by aner on 01-25-2010
  • SQLite Sample Application

    So I just started working for this company, and my boss the optimist said, BTW, I need you to create an application that does XYZ by January 1st. That would be fine and all except my toolkit is totally new (I am a web LAMP/PHP guy) and maybe I have bit off more than I can chew. I know anyone who could...
    Posted to Feature Requests (Forum) by alsbury on 12-05-2009
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems