示例#1
0
        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);
            }
        }
示例#2
0
 public static void AddConnection(DbConnectionConfig dbConfig)
 {
 }