You are using the straight SQLite classes to execute commands and such. Why not use EF6 and use SQLite as a data source. All the visual studio stuff works with it just the same a SQL server. If you can use .Net 4.0 or 4.5 then that is the way to go. You can use the EF 6 entity diagrams to design the DB and use EF 6 and LINQ to access it.
> On Jun 22, 2014, at 12:36 PM, Baruch Burstein <bmburst...@gmail.com> wrote: > > This is not technically sqlite specific, rather .net in general, but it > came up using sqlite.net, so I am asking here. If someone can point me to a > general answer elsewhere, that would be great, too. > I downloaded and "installed" (read: copied) the files to my project. I can > create connections, commands, etc. but how do I get it to recognize my data > structure? I only need to display a single table (with editing) in a > datagrid, but it is very frustrating when I don't have any of the famed > Visual Studio support for my types. Even if I create a structure manually > that represents a single row, how do I load the data into it? How do I bind > the grid to it? How do I search? I am not very familiar with C#, and the > little I have done always involved connecting to a "datasource", which > auto-populates everything, from creating a class to hold a row to Linq > intellisense support (I suspect the two are related). How do I get this to > work if I "Xcopy" installed, as recommended on the website? > > Basically, can someone point me to a resource on using databases in C# only > via manual code? > > Baruch > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
