NPVR Database connection

[ralphy]

My limited knowledge has me stumped...

What the equivalent NPVR code for this GBPVR code? I've tried various combinations of the methods available in the DatabaseHelperFactory but no joy to date:confused:

Code:

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

SQLiteCommand command = connection.CreateCommand();
command.CommandText="select * from CHANNEL";
sqlite_datareader=command.ExecuteReader();

connection.Close();

Is the ConnectionString = "Data Source=\""+NUtility.SettingsHelper.GetInstance().GetDataDirectory()+"npvr.db3\";Version=3;";

[mvallevand]

I use

Code:

string clientMode = SettingsHelper.GetInstance().GetSettingsNode("//Recording/ClientMode").InnerText;
        string dbLocation = null;
        if (clientMode != "true")
        {
                dbLocation = SettingsHelper.GetInstance().GetDataDirectory();
        }
        else
        {
                dbLocation = SettingsHelper.GetInstance().GetSettingsNode("//Recording/DatabaseShare").InnerText.TrimEnd('\\') + "\\";
        }
        dbCon.ConnectionString = "Data Source=\"" + dbLocation + "npvr.db3\";Version=3;New=True;";

Martin

[sub]

Code:

DatabaseHelper databaseHelper = DatabaseHelper.GetInstance();
            DbConnection connection = databaseHelper.GetConnection();
            DbCommand command = databaseHelper.CreateCommand(connection, query);
            
            DbDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                     ....
            }

            databaseHelper.FreeConnection(connection);

...but if you really just want the list of channels, then I'd do this:

Code:

List<Channel> channels = Channel.LoadAll()

[ralphy]

Thanks for your help guys.

...but if you really just want the list of channels, then I'd do this:

Code:

List<Channel> channels = Channel.LoadAll()

Actually, I want to find out the details of the of the playing recording, or the liveTV (ie title, description, channel number, channel name etc). I have been doing this by receiving the filename from an eventnotification and querying the database. Are there any methods to do this other than using an SQL query?

[sub]

You can get the list of channels with:
List<Channel> channels = Channel.LoadAll()

You can get the list of recordings with:
List<ScheduledRecording> records = ScheduledRecording.LoadAll()

There isnt really methods to directly get ScheduledRecording from the information you see in the events, but you could load all, and look for the ScheduledRecording with the filename reported in the event.