I think I may be missing a key piece of documentation, but I've been searching through this forum, and the documentation that came with my SQLite installer, but nowhere can I find any examples of how to actually use the designer generated commands. I am a bit of a beginner to SQLite, so that probably doesn't help.
For example, I am using Visual Studio for C# .Net and I used the visual designer to set up my table, and now I want to add some records to my empty table. I just can't figure out how to use the SQLiteInsertCommand1 function for the life of me. I realize it's just an instance of SQLiteCommand that is set up to insert data into the proper fields, but where do I define what data gets inserted? Do I still need to make a full SQL command string? If so, the whole prospect of a generated "Insert Command" seems a bit useless.
Every example I have found seems to just show SQL commands being used. Does no one use the generated commands? (The ones shown being generated in that quick overview video on the main page.)
I noticed that when I had the wizard generate those commands for me (Insert, Select, Delete, Update) it added a sizable chunk of code to my progam, I am hopeing they are actually simple to use as a result. Am I just wasting my time? Should I just use SQL commands like everyone else seems to be doing?
Anyway, I seem to be completely lost, can someone aim me in the right direction? It'd be greatly appreciated.