Re: [sqlite] sqlite.net (a.k.a. System.Data.SQLite) support

[Sean McBride]

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  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

[sqlite] sqlite.net (a.k.a. System.Data.SQLite) support

[Baruch Burstein]

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