static private void FetchAll() { if (cache == null) { cache = new Dictionary <long, TravelLogUnit>(); UserDatabase.Instance.ExecuteWithDatabase(cn => { List <TravelLogUnit> list = new List <TravelLogUnit>(); using (DbCommand cmd = cn.Connection.CreateCommand("select * from TravelLogUnit")) { using (DbDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { TravelLogUnit sys = new TravelLogUnit(rdr); cache[sys.id] = sys; list.Add(sys); } } } }); } }
static public List <TravelLogUnit> GetAll() { List <TravelLogUnit> list = new List <TravelLogUnit>(); using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: SQLLiteExtensions.SQLExtConnection.AccessMode.Reader)) { using (DbCommand cmd = cn.CreateCommand("select * from TravelLogUnit")) { using (DbDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { TravelLogUnit sys = new TravelLogUnit(rdr); list.Add(sys); } } return(list); } } }
static public List <TravelLogUnit> GetAll() { return(UserDatabase.Instance.ExecuteWithDatabase <List <TravelLogUnit> >(cn => { List <TravelLogUnit> list = new List <TravelLogUnit>(); using (DbCommand cmd = cn.Connection.CreateCommand("select * from TravelLogUnit")) { using (DbDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { TravelLogUnit sys = new TravelLogUnit(rdr); list.Add(sys); } } } return list; })); }
static private void FetchAll() { if (cache == null) { cache = new Dictionary <long, TravelLogUnit>(); UserDatabase.Instance.ExecuteWithDatabase(cn => { using (DbCommand cmd = cn.Connection.CreateCommand("select * from TravelLogUnit")) { using (DbDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { TravelLogUnit sys = new TravelLogUnit(rdr); System.Diagnostics.Debug.Assert(!cache.ContainsKey(sys.ID)); cache[sys.ID] = sys; } } } }); } }
static public List <TravelLogUnit> GetAll() { List <TravelLogUnit> list = new List <TravelLogUnit>(); using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader)) { using (DbCommand cmd = cn.CreateCommand("select * from TravelLogUnit")) { DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd); if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { return(list); } foreach (DataRow dr in ds.Tables[0].Rows) { TravelLogUnit sys = new TravelLogUnit(dr); list.Add(sys); } return(list); } } }
public static bool TryGet(long id, out TravelLogUnit tlu) { tlu = Get(id); return(tlu != null); }
public static bool TryGet(string name, out TravelLogUnit tlu) { tlu = Get(name); return(tlu != null); }