public override List<PackageFile> FillPackageFiles(string packageId)
{
var files = new List<PackageFile>();
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
using (var cmd = conn.CreateTextCommand(string.Format("SELECT PackageId, FileOrder, FilePath, IsDirectory FROM {0}PackageFiles ", this.tablePrefix)))
{
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var f = new PackageFile()
{
PackageId = rdr.GetString(0),
FileOrder = rdr.GetInt32(1),
FilePath = rdr.GetString(2),
IsDirectory = rdr.GetBoolean(3)
};
files.Add(f);
}
}
}
}
}
return files;
}