public List <Book> GetBooks()
{
var sqlSelect = $"select * from {_tableName}";
var result = DBSQLiteCommand.ExecuteReader <Book>(sqlSelect, null, (readerItem =>
{
var item = new Book();
item.FromReader(readerItem);
return(item);
}));
return(result);
}
public DBInfo GetInfo()
{
var sqlFirst = $"select * from {_tableName} limit 1";
var result = DBSQLiteCommand.ExecuteReader <DBInfo>(sqlFirst, null, (readerItem =>
{
var item = new DBInfo();
item.FromReader(readerItem);
return(item);
}));
var info = result.FirstOrDefault();
return(info);
}
public Book GetBook(string id)
{
var sqlFirst = $"select * from {_tableName} where {_columnName_ID} = @id limit 1";
var parameters = new SQLiteParameter[] { new SQLiteParameter("@id", id) };
var result = DBSQLiteCommand.ExecuteReader <Book>(sqlFirst, parameters, (readerItem =>
{
var item = new Book();
item.FromReader(readerItem);
return(item);
}));
var book = result.FirstOrDefault();
return(book);
}