封装一个泛型的数据库访问查询方法

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;
   }