public ActionDataSet(IRfcpLocalConextProvider localcontextpovider) { data = new List <IActionData>(); using (SQLiteConnection dbConn = new SQLiteConnection(localcontextpovider.Get(CpLocalContextType.Rfcp).GetDbNameWithPath)) { dbConn.Open(); SQLiteCommand cmd = dbConn.CreateCommand(); cmd.CommandText = "SELECT * FROM ActionTable"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { data.Add( new ActionData( (ushort)reader.GetInt32(0), (ushort)reader.GetInt32(1))); } cmd.Dispose(); reader.Dispose(); dbConn.Close(); } }
public StringPropertyDataSet(IRfcpLocalConextProvider localcontextpovider) { data = new List <IStringPropertyData>(); using (SQLiteConnection dbConn = new SQLiteConnection(localcontextpovider.Get(CpLocalContextType.Rfcp).GetDbNameWithPath)) { dbConn.Open(); SQLiteCommand cmd = dbConn.CreateCommand(); cmd.CommandText = "SELECT * FROM BoolPropertyTable"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { bool temp; Boolean.TryParse(reader.GetString(2), out temp); data.Add( new StringPropertyData( (ushort)reader.GetInt32(0), (ushort)reader.GetInt32(1), reader.GetString(2))); } cmd.Dispose(); reader.Dispose(); dbConn.Close(); } }