2021-05-17 C#.NET面试题 请使用C#的相关知识，封装一个泛型的数据库访问查询方法；

请使用C#的相关知识，封装一个泛型的数据库访问查询方法；

 public T Get<T>(int id) where T : BaseModel
        {
            string ConnectionString = "Data Source=DESKTOP-63QE7M1; Database=CustomerDB; User ID=sa; 				Password=sa123; MultipleActiveResultSets=True";
            Type type = typeof(T); 
            var propList = type.GetProperties().Select(p => $"[{p.Name}]");
            string props = string.Join(',', propList);  
            string tableName = type.Name;
            string StringSql = $"select {props} from [{tableName}] where id=" + id; 
            object oInstance = Activator.CreateInstance(type);
            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                connection.Open();
                SqlCommand sqlCommand = new SqlCommand(StringSql, connection);
                SqlDataReader reader = sqlCommand.ExecuteReader();
                reader.Read();
                foreach (var prop in type.GetProperties())
                {
                    prop.SetValue(oInstance, reader[prop.Name]);
                }
            }
            return (T)oInstance;
        }