in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » autoincrement (RSS)

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

  • Autoincrement Seed

    Hi, I've been having an issue with using autoincrementing primary key columns. When filling a DataTable from a DataAdapter, the adapter has the MissingSchemaAction.AddWithKey parameter set. The problem is that the autoincrement seed is not being set correctly. It sets the autoincrement seed to be...
    Posted to General (Forum) by drspock on 04-06-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

  • Entity Framework - edmx file - primary key - autoincrement (StoreGeneratedPattern="Identity")

    I'm using VB.Net in Visual Studio 2008 and SQLite Expert 2.3.19.1936 to generate the database and create the table and version 1.0.65.0 of System.Data.SQLite Here's my table creation: CREATE TABLE app_param ( param_id INTEGER, param TEXT NOT NULL, info TEXT NOT NULL, PRIMARY KEY(param_id ASC...
    Posted to Bugs (Forum) by magik on 01-09-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

  • AUTOINCREMENT Problem

    System.Data.Sqlite version = 1.0.60, VS 2005 I have a table that I should have set the Primary Key to be [NewsletterID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT but, in ignorance I set it to be [NewsletterID] SMALLINT NOT NULL PRIMARY KEY. The result seemed to be that the primary key was not automatically...
    Posted to How To (Forum) by rkulp on 11-24-2008

  • Re: autoincrement column from database

    You can query table 'sqlite_.sequences' to find all tables which they have autoincrement PKs. Then use connection.GetSchema("columns") to get all PKs.
    Posted to Feature Requests (Forum) by Snax on 11-26-2007

  • autoincrement column from database

    is it hard to implement property like: bool GetAutoincementPrimaryKeyValueFromDataSource (true/false) to the primary key column that after dataadapter.insert will get last_insert_rowid() and set this value to proper column in datatable? it would easy application developing, i think:) or maybe it...
    Posted to Feature Requests (Forum) by Wiaz on 08-13-2007
Page 1 of 1 (9 items)
Powered by Community Server (Commercial Edition), by Telligent Systems