public static List <DbConnectionConfig> GetAllConnections() { List <DbConnectionConfig> res = new List <DbConnectionConfig>(); using (configConnection) { GetConfigConnection(); try { var da = new SQLiteDataAdapter("select * from tblConnections", configConnection); var tbl = new DataTable(); da.Fill(tbl); foreach (DataRow rw in tbl.Rows) { DbConnectionConfig obj = new DbConnectionConfig(); obj.ID = Convert.ToInt32(rw[0].ToString()); obj.Name = rw[1].ToString(); obj.DbType = (Core.DbType)Convert.ToInt32(rw[2].ToString()); obj.ConnectionString = rw[3].ToString(); res.Add(obj); } } catch (Exception) { } return(res); } }
public static void AddConnection(DbConnectionConfig dbConfig) { }