public byte[] Find(TileIndex index)
{
if (IsTileIndexValid(index))
{
byte[] result;
var cn = new SQLiteConnectionWithLock(_platform, _connectionString);
using (cn.Lock())
{
const string sql =
"SELECT tile_data FROM \"tiles\" WHERE zoom_level=? AND tile_row=? AND tile_column=?;";
result = cn.ExecuteScalar <byte[]>(sql, int.Parse(index.Level), index.Row, index.Col);
}
return(result == null || result.Length == 0
? null
: result);
}
return(null);
}
public byte[] GetTile(TileInfo tileInfo)
{
var index = tileInfo.Index;
if (IsTileIndexValid(index))
{
byte[] result;
using (var cn = new SQLiteConnectionWithLock(_connectionString))
using (cn.Lock())
{
var sql = "SELECT tile_data FROM \"tiles\" WHERE zoom_level=? AND tile_row=? AND tile_column=?;";
result = cn.ExecuteScalar <byte[]>(sql, index.Level, index.Row, index.Col);
}
return(result == null || result.Length == 0
? null
: result);
}
return(null);
}
