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
