private static DataTable Select(SQLiteConnection connection, string sql, params object[] args)
{
using (var database = new PetaPoco.Database(connection))
using (var cmd = database.CreateCommand(database.Connection, sql, args))
{
using (var adapter = new SQLiteDataAdapter((SQLiteCommand)cmd))
{
var table = new DataTable();
adapter.Fill(table);
return(table);
}
}
}
public DataTable Select(string sql, params object[] args)
{
using (var connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
using (var database = new PetaPoco.Database(connection))
using (var cmd = database.CreateCommand(database.Connection, sql, args))
{
using (var adapter = new SQLiteDataAdapter((SQLiteCommand)cmd))
{
var table = new DataTable();
adapter.Fill(table);
return table;
}
}
}
}
