Can you attach some code samples showing usage in that way? Sent via BlackBerry from T-Mobile
-----Original Message----- From: Don V Nielsen <[email protected]> Sender: [email protected] Date: Fri, 16 Dec 2011 08:53:41 To: General Discussion of SQLite Database<[email protected]> Reply-To: General Discussion of SQLite Database <[email protected]> Subject: Re: [sqlite] SQLite with Vis. Studio C# My application never uses a DataSet. I push all db responsibility to sqlite. It returns DbDataReaders when I need to recurse through results. On Thu, Dec 15, 2011 at 1:40 PM, Jeff Matthews <[email protected]> wrote: > Regarding my earlier question as to .NET SQlite syntax, I was wondering if > I > had to use DataAdapters and create and fill objects (DataSets), or not. > > Here is some sample code dealing with SQLite in C#: > http://www.codeproject.com/KB/cs/SQLiteCSharp.aspx > > It looks to me like he is loading the database into a DataSet and then, > doing his thing on the DataSet, rather than on the database directly. > > See how he is building his query as a string (surrounded by quotes) and > then, calling a function to conduct it? > > Is this necessary - i.e., is this the only way to query and manipulate > SQLite data from C#? > > I was thinking that we could just use sql statements literally, without > having to send them as a string to a function. > > Does my question make sense? > > Can it not be done just using the sql literally and skipping all the > DataAdapter, DataSet stuff? > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
