I want to use SQLite in a C# app I am developing.
My database knowledge drops off around 1996, when I gave up Clipper
programming. I have since learned a little about some of the new methods
used by database gurus. But I remember Clipper like it was yesterday since
I did so much of it.
Here is a short snippet of the logic I recall using back when:
Select (0) // Provides allocation for a new file handle for opening a
database
Use Customers // Will open Customers dbf, where in those days, each table
was its own file, and thus, we had multiple dbf files in an app to use
relational data.
Set Index to Phone, LastName // The indexes were also stored in separate
files.
Set Order to 2 // This would mean that our seeks would use the LastName
index's sort order
seek "MATTHEWS" // Try to find the first instance of search string in the
index and move record pointer to the row, or if not found, eof()
numrecs=0
if found();
do while trim(upper(LastName))="MATTHEWS" .and. !eof() //
cycle through the records and stop if eof() is hit
delete // delete the entire row
numrecs=numrecs+1
skip // go to next record
enddo
endif
showMessage(ltrim(str(numrecs,0))+" records deleted.")
That's it.
I am not wanting to have to deal with excitingly new ways to do all this,
such as DataSets or Entities, unless someone says, "But, you must!" or
"You're crazy not to."
So, which is the best SQLite download for me to use in C# using the closest
syntax and logic flow as set forth above? I am ready to download and start
hacking.
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
