System.Data.SQLite

Greetings,

I feel like a bit of a pest, seeing that similar questions were asked at least 3 times before. But then I am also a bit confused, since I am not quite sure if the feature I am looking for is available in the first place ...

I installed the design time support for VS and can create a new SqLite database just fine and subsequently connect to it again.

I kinda expected to be able to right click on the 'Tables' entry and select something like 'Create Table', yet the only options I get are 'New Query',  'Refresh', 'Properties'.

As I said, I am not sure if I am making a complete fool of myself here f that feature is not yet available, but the some posts indicate that it is.

Thanks for your time :)

 

Creating tables via integrated GUI is still being developed.  I've got the code about halfway written.  For now you have to make a new query and write the SQL yourself.

Robert

 

I saw in a Visual Studio demo that in Server Explorer you can right-click on Tables and "Add new table" ... is this the capablity you're talking about adding to future versions?
Thanks!

Hows your work going on this? I guess at the moment we could just use SQLite Administrator to create our tables with a designer.
http://sqliteadmin.orbmu2k.de/
Is that what you would use? I guess the main reason I was looking at using a server explorer designer written by you is so that I can verify I'm correctly making a db with types which are compatible with the .net types in your ADO implementation. However this probably isn't that big a deal.

Work has been on hold on this, primarily for time reasons.  I have some deadlines coming up at work that have nothing to do with SQLite, so my time's been limited to maintenance at the moment.

Robert