public static void DbTests() { var db = new Sqlite3("BookDB.sqlite3"); using (var r = db.ExecuteReaderOne("select count(*) from book")) { var v = r.GetValues(); foreach (var i in Enumerable.Range(0, r.FieldCount)) { Console.WriteLine("{0}: {1}", v.GetKey(i), r.GetValue(i)); } } }
public Book GetBook(int bookId) { using (var r = DB.ExecuteReaderOne("select * from book where book.id=?", 1)) { if (r == null) { return(null); } var book = new Book(r.GetString(1), r.GetDateTime(2), r.GetString(3)) { Id = r.GetInt64(0) }; book.Hrefs.AddRange(GetHrefs(book.Id)); book.Categorys.AddRange(GetCategorys(book.Id)); book.Tags.AddRange(GetTags(book.Id)); return(book); } }