System.Data.SQLite

I'm using the latest version of SQLite posted today (1.0.26.0).

I watched the tutorial video and got to work. So far, I've added a connection to the database with the server explorer in visual studio 2005 and executed some scripts to create four tables. So far, so good.

However, in the video I noted that you when you create a new query and then add a table to it, you can actually see all of the columns of the table in the design view. All I ever see is the table with the (All Columns) checkbox. If I execute a select * from query I can see that my query is returning all of the columns so I'm pretty sure they exist.

So is there a setting I'm missing or is something wrong?

Thanks!

That's odd.  What's the table definition look like?  Also, I've posted 1.0.26.1 earlier today -- but the revision would not affect this.

Robert

I just downloaded the 1.0.26.1 and there is no difference. I never get any of the columns listed in the designer.

Here's the SQL I used to create one of the tables. It's exceedingly simple stuff.

CREATE TABLE Term (TermId INTEGER IDENTITY (1, 1) NOT NULL,
     Term NVARCHAR(250) NOT NULL,
     Replacement NVARCHAR(250) NOT NULL)

Ok I'll recreate this here and see if I get the same problem.  For the record, SQLite doesn't understand IDENTITY(1,1)  you need to replace it with AUTOINCREMENT I think ... Preferably PRIMARY KEY AUTOINCREMENT

Robert

I changed the script to this:

CREATE TABLE Term (TermId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
     Term NVARCHAR(250) NOT NULL,
     Replacement NVARCHAR(250) NOT NULL)

No change in the behavior of the designer for me.

Ok, I'll see if I can duplicate the bug here and will post back afterwards.

Robert

I can't duplicate this bug ...

I copied and pasted your create table statement into a database and can see everything fine.

Did you perchance have an older version of the library installed at any point in time?  Check the global assembly cache and make sure no old versions exist there.

Also re-run the install.exe program.

Robert

The first version I ever had installed was 1.0.25.0, removed everything from the GAC (after seeing another thread) and installed .26.0 this morning. Did the same thing with the 26.1 this afternoon when I noticed that you had posted it. I'll start again from scratch tomorrow morning and see how things go.

Thanks again.

E-mail me your database.  robert at blackcastlesoft dot com