public static List <T> ExecuteReader <T>(string sqlCommand, SQLiteParameter[] parameters, Func <SQLiteDataReader, T> converter) { var conn = DBSQLiteConnection.CreateOrGet(); var comm = conn.CreateCommand(sqlCommand, parameters); conn.OpenConnection(); try { SQLiteDataReader dataReader = comm.ExecuteReader(); List <T> res = new List <T>(); while (dataReader.Read()) { res.Add(converter(dataReader)); } return(res); } catch (Exception ex) { throw; } finally { conn.CloseConnection(); } }
public static DBSQLiteConnection CreateOrGet() { var ins = SQLiteConnectionFactory.Restore(); if (ins == null) { lock (_OBJECT_LOCK) { ins = SQLiteConnectionFactory.Restore(); if (ins == null) { ins = new DBSQLiteConnection(); SQLiteConnectionFactory.Cache(ins); } } } return(ins); }
public static void ExecuteNonQueryCommand(string sqlCommand, SQLiteParameter[] parameters) { var conn = DBSQLiteConnection.CreateOrGet(); var comm = conn.CreateCommand(sqlCommand, parameters); conn.OpenConnection(); try { comm.ExecuteNonQuery(); } catch (Exception ex) { throw; } finally { conn.CloseConnection(); } }
public static object Cache(DBSQLiteConnection obj) { _FACTORY.SetDataSource(HttpContext.Current.Items); return(_FACTORY.Cache(obj, _key)); }