public IEnumerable <Test> Get() { _ConnectionFactory = new SQLConn(); IEnumerable <Test> nsctube = new List <Test>(); using (var cn = _ConnectionFactory.CreateConnection()) { string sql = " select T6091F08 from DTB6091 where T6091F08='8937' "; nsctube = cn.Query <Test>(sql).ToList(); } return(nsctube); }