Getting LiveTV Details

[ralphy]

What is the best way to get details of the LiveTV currently playing including, Program description, start time, end time? Channel Name and Number come through as an event notification, but I have not been able to get any GBPVRPublic methods or properties to get the other details. (Perhaps I'm using the wrong ones, or trying them the wrong way)

So I extract these details directly from the database. The problem is that I suspect that this might be the cause of some random pausing and stuttering during LiveTV playback, since I assume that the connection.Open() (see below) locks the database for exclusive access until connection.Close() is called and maybe PVRX2 is waiting to gain access too. For my code, this takes between 150-200mS, and is done every 30 seconds, since the program details will change at the end of a show, and I want to get the current information.

Code:

connection = DatabaseHelperFactory.getDbProviderFactory().CreateConnection();
connection.ConnectionString=GBPVRInfo.GBPVRDBConnectionString;
connection.Open();

Could a locked database be the cause of the stuttering?
How can I best get the data I want from the database?
Can I open the database non-exclusively/readonly, and if so how?

[sub]

There is no public API for accessing this type of info. About the only way you could get this info is accessing the database like you currently are.

I'm fairly sure the database isnt locked unless you do an update, and then I think its only locked for the duration of that statement.

You're correct that database access could cause a momentary blip, so you'd be best to cache the last programme details loaded from the database until the either the channel changes or the end time of the show passes. No point in re-reading the info if you know its still the same show.

[ralphy]

No point in re-reading the info if you know its still the same show.

Great idea - I need to stand back and look at the forest rather than the trees. I guess this happens sometimes. Hopefully this will reduce the likelihood of the stutter.

Thanks sub!